Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing the sort order
Message
 
To
06/05/2002 09:30:15
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00653027
Message ID:
00653047
Views:
19
>For reports with data grouping (subtotals), using a single report is more complicated, but I think it could be done, too. (For instance, copy the fields required for grouping to a separate field, using always the same fieldname for different grouping criteria).


If you have data grouping you can set up the data group with an expression of ... EVALUATE(lcMyGroup) ... where lcMyGroup is an expression that you can define in the program that calls the report. This way, you can set the expression to whichever sort order you are using. Depending on how the indexes are set, you may be able to use EVALUATE(KEY()) and not worry about a variable.

Cathy
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