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

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 6:20PM
    0 obased index
    if cell is cross1cell0
    mycross.CellFunctions[0]:= cfsum; //cfnone cfmax cfmin cfcount

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.