Hi,
I need to display the description next to SUBTOTAL and I have more than one SUBTOTAL.
Example:
For CAR subtotal I want in the desc as CAR and for COUNTRY subtotal I want as COUNTRY in the column DESC. Can this be implemented using DEFINE ?

 SET BYDISPLAY=ON
DEFINE FILE CAR
DESC/A20V= 'DATA';
END

TABLE FILE CAR
SUM
DEALER_COST
RETAIL_COST
DESC
BY COUNTRY
BY CAR
ON COUNTRY SUBTOTAL AS 'Total For:'
ON CAR SUBTOTAL AS 'Total For :'
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=SUBTOTAL,JUSTIFY=RIGHT,$
TYPE=REPORT,GRID=OFF,$
END
-EXIT 

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

Your DESC field is a alpha field, so it will not be included in the subtotal.
Your only chance (as far as I can think of) is to do your subtotals as a subheading and aligning it with the data columns. That way you can include the desired text with your subheading.

How about this?

SET BYDISPLAY=ON
DEFINE FILE CAR
DESC/A20V= 'DATA';
END

TABLE FILE CAR
SUM
DEALER_COST
RETAIL_COST
DESC
BY COUNTRY
BY CAR
ON COUNTRY RECOMPUTE * AS 'Total For:'
ON CAR RECOMPUTE * AS 'Total For :'
ON TABLE RECOMPUTE * AS 'TOTAL'
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=SUBTOTAL,JUSTIFY=RIGHT,$
TYPE=REPORT,GRID=OFF,$
END
-EXIT 

I'd go with GamP's suggestion:

  
DEFINE FILE CAR
DESC/A20= 'DATA';
COUNTRYDESC/A12='COUNTRY';
CARDESC/A12='CAR';
END

TABLE FILE CAR
PRINT
DEALER_COST
RETAIL_COST
DESC 
BY COUNTRY
BY CAR
ON CAR SUBFOOT
"Total<CAR<ST.DEALER_COST<ST.RETAIL_COST CAR"
ON COUNTRY SUBFOOT
"Total<COUNTRY<ST.DEALER_COST<ST.RETAIL_COST COUNTRY"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=SUBTOTAL,JUSTIFY=RIGHT,$
TYPE=REPORT,GRID=ON,$
TYPE=SUBFOOT, HEADALIGN=BODY, $
TYPE=SUBFOOT, ITEM=3, JUSTIFY=RIGHT, $
TYPE=SUBFOOT, ITEM=4, JUSTIFY=RIGHT, $
END

I like it. But, do these two lines do anything for you?

COUNTRYDESC/A12='COUNTRY';
CARDESC/A12='CAR';

Or, just left-overs?

Hi Danny,
Your solution works for me. Thanks for the help.

Regards,
SAMM

Doug,
You are right: left-overs from trying to use SUBTOTAL/RECOMPUTE.
Oh well...

SAMM,
Happy to help.