sort selection table

[Kenneth Brody]

On 10/11/2016 3:09 PM, daN baueR via Filepro-list wrote:
> Just wondering if if this environment is too old for this trick. The OS is
> AIX with a old version of filePro 4.5. Or is this just not possible?
>
> The report in question was setup in a header file with the body of the
> report pulling all of the detail lines from another file. This works but
> the detail lines aren't sorted the way I'd like them to be.
> The V sort/selection table prompts for a single building code and then the
> report processing uses a loop and a print command to get and all of the
> data lines.
> I added a sort command to the -v table but it doesn't affect order of the
> data lines. The print command can't go in the V table. So is it possible to
> sort the report if all of the data uses dummy variables coded in the output
> form?
>
> I know I can recreate the report and base it in the detail file. The
> problem is It's a larger than normal header and I'm trying not to recode
> the whole thing.

The SORT command will change the output order of the records being selected 
by the sort/select processing.  However, if the output processing then does 
a LOOKUP/GETNEXT/PRINT loop to print multiple detail items for each main 
record, this has nothing to do with the SORT from sort/select.  The records 
will print in the exact order that you PRINT them.  If you need the detail 
record printed in a different order, then you'll need to PRINT them in a 
different order.  Perhaps create an index in that order, and use that index 
for the LOOKUP?

-- 
Kenneth Brody