Re: Single select, multiple reports-sorts-headings

[Kenneth Fraser <Ken.Fraser@WORLDNET.ATT.NET>]

Darwin,
    Wait until I get in.

            The Real Ken

-----Original Message-----
From: Ken Eister <WKEISTERJR@AOL.COM>
To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
Date: Monday, July 06, 1998 8:51 PM
Subject: Re: Single select, multiple reports-sorts-headings


>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