I have a report that has a subtotal for each vendors various expenses. How can I sort on that subtotal so I can view the vendor with the highest expenses to the vendor with the lowest expenses but yet keep the various expense (dont want to aggregate) categories for each vendor?

Just off the top of my head, how about a multi-verb request, the first one being the summarization sorting BY HIGHEST and the second being the detail?

And to add to Ginny's comment, you can do a NOPRINT on the output of the first verb so it doesn't show on the report, just the detail you want.

This is the code where I have tried to take your suggestions. I am still not able to get the detail on the last three fields.


TABLE FILE LRDRAFT
SUM
DRAFTAMT
SSEMPIDNO

print EXPTYP
PAYCODE
DraftAMT
BY HIGHEST DRAFTAMT NOPRINT
BY PAYEENAME

ON PAYEENAME SKIP-LINE
HEADING
"Total Payee Expenses Paid in the CASRS system Between 01/01/07 to 12/31/07"
" "
FOOTING
" "
"&DATE <+0>

Try something like this (the keyword TOTAL should solve the problem):

TABLE FILE CAR
SUM
RETAIL_COST NOPRINT
BY HIGHEST TOTAL RETAIL_COST NOPRINT
BY COUNTRY 

SUM
RETAIL_COST
BY HIGHEST TOTAL RETAIL_COST NOPRINT
BY COUNTRY
BY CAR

ON COUNTRY SUBTOTAL AS 'TOTAL'

END

You need to sort the sales in the summary section of your report. Use this as an example:

 TABLE FILE CAR
SUM SALES
BY HIGHEST TOTAL SALES NOPRINT
BY COUNTRY
PRINT SALES
BY HIGHEST TOTAL SALES NOPRINT
BY COUNTRY 
BY CAR
END 

Great minds think alike, Francis.

Yup!