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