How to set Sort Order (Column/Row) and Aggregate(Cell) of TfrxDBCrossView using code
I need to use code to real time generate quite complicated reports, including using TfrxDBCrossView sometime.
I see that most options I can set using the Cross-Tab Editor can be access via its published properties.
However, I cannot find how to set the Ordering (Ascending / Descending, etc) of Row and Column, as well as Aggregate (Sum, Count, etc) of Data Cell.
May I know how to set those using code when creating the TfrxDBCrossView?
I had searched the forum but cannot find much help in this issue.
Thanks in advance.
Justmade
I see that most options I can set using the Cross-Tab Editor can be access via its published properties.
However, I cannot find how to set the Ordering (Ascending / Descending, etc) of Row and Column, as well as Aggregate (Sum, Count, etc) of Data Cell.
May I know how to set those using code when creating the TfrxDBCrossView?
I had searched the forum but cannot find much help in this issue.
Thanks in advance.
Justmade
Comments
if cell is cross1cell0
mycross.CellFunctions[0]:= cfsum; //cfnone cfmax cfmin cfcount