So, I have a group field with one of two values: REVENUE OR EXPENSES.

I want to report the account detail and a total footer for each. But I'd also like a header prior to the detail...see below...

REVENUE:
.
.
detail
.
.
Revenue Total

EXPENSES
.
.
detail
.
.
EXPENSES Total


Is this possible?

This message has been edited. Last edited by: <Kathryn Henning>,

look up sub headings

You could also lookup WHEN......
For example....
ON GRPFLD SUBTOTAL xxxxx WHEN GRPFLD EQ 'Revenue';
ON GRPFLD SUBTOTAL xxxxx WHEN GRPFLD EQ 'Expenses';

tried this...but it still does not print the country name, for example...in the sub heading...what am I missing...

TABLE FILE CAR
SUM
CAR.BODY.RETAIL_COST
BY LOWEST CAR.ORIGIN.COUNTRY NOPRINT
BY LOWEST CAR.COMP.CAR
BY LOWEST CAR.CARREC.MODEL
BY LOWEST CAR.BODY.BODYTYPE
BY LOWEST CAR.SPECS.LENGTH
BY LOWEST CAR.SPECS.WIDTH

ON CAR.ORIGIN.COUNTRY SUBHEAD
" "
ON CAR.ORIGIN.COUNTRY SUBTOTAL AS '*TOTAL'
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE ROW-TOTAL AS 'TOTAL'
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *

quote:

what am I missing...

Just

ON CAR.ORIGIN.COUNTRY SUBHEAD
"<COUNTRY"