SUMMARY: Substitute footing print based on subtotal.
Jesse, Rich
Rich.Jesse@qtiworld.com
Fri, 20 Apr 2001 10:52:26 -0500
Thanks to Allen Jones for suggesting that I use MAXIMUM in the FOOTING.
Works like a charm! Now if I can just get the rest of my code to work...
:)
Rich Jesse System/Database Administrator
Rich.Jesse@qtiworld.com Quad/Tech International, Sussex, WI USA
-----------
Allen Jones replied:
> So long as the collating sequence places "N" before "Y", you might be able
> to use the MAXIMUM function
> DEFINE MY_TEST_Y char*1 = "Y" IF MY_COLUMN = "Y" ELSE "N"
> DEFINE MY_TEST_Z char*1 = "Y" IF MY_COLUMN = "Z" ELSE "N"
> ...
> FOOTING AT MY_INDEX_COLUMN
> MY_INDEX_COLUMN &
> MY_TEST_X MAXIMUM &
> MY_TEST_Y MAXIMUM &
> ...etc.
>
> I haven't tried it (re: specific syntax), but if I understand your
question
> correctly, something like this might give you what you want.
-----------------------------------------------------------------------
This message has been scanned for viruses with Trend Micro's Interscan VirusWall.