Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing the sort order
Message
From
06/05/2002 09:30:15
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
06/05/2002 09:17:55
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00653027
Message ID:
00653031
Views:
21
>Hello Group,
>
>I have three requests for reports differing only in the sort order. Can I make a two copies of the first one I create and just change the sort order some how?
>
>What is my best approach?
>
>Thanks
>Jim

For simple listings, you can use a single report.

Eliminate the table from the report's Data Environment.

Select your data, with different sort orders (use SELECT - SQL), and then run the report.

Make the report header depend on a variable.

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).

HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform