FYI ... you can define the Data Group as an expression that gets evaluated at runtime so you don't have to hack the FRX to change it. For example .. set a variable to the field you want it grouped by:
cGroupExpr = 'MyField'
REPORT FORM MyReport ...
And make sure the Data Group in the report is defined with the following expression:
EVALUATE(cGroupExpr)
Catby
>Dear Sergey,
>
>Thanks for the confirmation. Now, all I have to do to generalize a standard report is change the EXPR field (grouping condition) and change the sort order coming back from MS SQL and this report can handle any number of REPORT BY Work Order Type, Work Order Cost Center, etc. condtions.
>
>What do you think?
>
>Regards,
>
>Jim Smith
>>Yes, it's stored in the Expr field of the Band/Group header (ObjType=9 and ObjCode=3).
>>
>>>Does anyone know whether the Grouping Condition for the report is always stored in the FRX record that contains field ObjType equal to 9 ObjCode equal to 3?
>>>
>>>Regards,
>>>
>>>Jim Smith