July 16, 2009, 09:00 AM
Doug Prarie: How simple was that!
Wasi: Anything else? Is this Closed?
July 16, 2009, 10:06 AM
mgrackinPrarie, Doug;
Not so fast. Adding the BY TOTAL HIGHEST statement only will sort the report based on the individual values of SALES, not the SUBTOTAL value of SALES. You need to do a bit more work.
Try this example:
TABLE FILE CAR
SUM SALES NOPRINT
BY TOTAL HIGHEST SALES NOPRINT
BY CAR
PRINT SALES SEATS
BY TOTAL HIGHEST SALES NOPRINT
BY CAR
BY MODEL
BY BODYTYPE
ON CAR SUBTOTAL SALES SEATS AS 'TOTAL CAR'
ON TABLE SET STYLE *
TYPE=REPORT, GRID=OFF, SQUEEZE=ON,$
TYPE=SUBTOTAL, BACKCOLOR=ORANGE,$
ENDSTYLE
END
July 16, 2009, 10:16 AM
mgrackinHere's another interesting approach to the issue:
TABLE FILE CAR
PRINT SUM.SALES WITHIN CAR NOPRINT SALES SEATS
COMPUTE SUMSALES/D12=C1; NOPRINT
BY TOTAL HIGHEST SUMSALES NOPRINT
BY CAR
BY MODEL
BY BODYTYPE
ON CAR SUBTOTAL SALES SEATS AS 'TOTAL CAR'
ON TABLE SET STYLE *
TYPE=REPORT, GRID=OFF, SQUEEZE=ON,$
TYPE=SUBTOTAL, BACKCOLOR=ORANGE,$
ENDSTYLE
END
July 22, 2009, 08:56 AM
mgrackinWasi,
Here is a link to the post that explains how to change the thread description to have [SOLVED] in the description.
http://forums.informationbuild...1057331/m/8871069592"To add this keyword to the subject title the member who began the thread should go to the
very first post that they started the thread with and then edit it. The subject title may only be changed by editing the very first post in the thread."