Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grouping variable listing in FRX
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00710341
Message ID:
00710443
Views:
16
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
Cathy Pountney, Microsoft Visual FoxPro MVP
Memorial Business Systems, Inc. (www.mbs-intl.com)

My Website: (www.frontier2000.com)
My Blog: (www.cathypountney.blogspot.com)
My Book: The Visual FoxPro Report Writer - Pushing it to the Limit and Beyond
Free MSDN Article: What's New in the VFP 9.0 Report Writer
Free MSDN Article: The VFP 9.0 Report Writer In Action
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform