Re: Single select, multiple reports-sorts-headings

[Ken Eister <WKEISTERJR@AOL.COM>]

Darwin, on occasions I've had to do what you need to do (create multiple
reports in multiple orders with a single select).  I do this by creating a
flat file from the the single select ....  Let the single select be ordered
for one of the 2 reports. While you are generating the 1st report via the
select, write to a flat file. At the end of the select (once all the data has
been retrieved), sort the flat file in the order of the 2nd report (via a unix
sort) and generate the 2nd report.

Ken