Hi,

I was creating a report and I noticed when I made used a subtotal, it would create it perfectly in the GUI.

But when I coded it using the
"ON FIELD_NAME SUBTOTAL AS 'Description' "

It would create the background colors for all the columns and not just the columns it has totals for.

Is there a way to create it so that the Wording and background color only starts on the column that it was made "on" and not previous columns?

Ben,

Does this answer your question:

TABLE FILE CAR
PRINT *
BY COUNTRY
ON COUNTRY SUBTOTAL AS 'Seats for: '

ON TABLE SET STYLE *

TYPE=SUBTOTAL, COLUMN=SEATS, BACKCOLOR=RED, $

ENDSTYLE
END

Regards,
Sean

This message has been edited. Last edited by: smiths,

Is this what you are trying to do?

TABLE FILE CAR
SUM
     RETAIL_COST
     DEALER_COST
BY COUNTRY
BY CAR

ON COUNTRY SUBTOTAL AS 'Description:'
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,SQUEEZE=ON,ORIENTATION=PORTRAIT,$
TYPE=REPORT,GRID=OFF,FONT='TIMES NEW ROMAN',SIZE=10,COLOR='BLACK',BACKCOLOR='NONE',STYLE=NORMAL,$
TYPE=SUBTOTAL,BY=COUNTRY,COLUMN=P3,COLOR='RED',BACKCOLOR='BLACK',$
ENDSTYLE
END

I think you guys are on the right track, but the text should start on the column that it is "on".

Report Columns:
COUNTRY COSTS PROFIT

If I do a subtotal on Costs, I want the Subtotal title to start under Costs, and not under Country.

If it does what you want in the GUI, then why don't you look at the source code generated by the GUI and do the same?

Is this what your are trying to do:

TABLE FILE CAR
SUM
     RETAIL_COST AS 'Retail,Cost'
     DEALER_COST AS 'Dealer,Cost'
     SALES AS 'Sales'
BY COUNTRY AS 'Country'
BY CAR AS 'Car'
BY BODYTYPE AS 'Body'

ON CAR SUBFOOT
" <+0>Description:<CAR<+0><ST.DEALER_COST"
" "
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
UNITS=IN,SQUEEZE=ON,ORIENTATION=PORTRAIT,$
TYPE=REPORT,FONT='ARIAL',SIZE=8,COLOR='BLACK',BACKCOLOR='NONE',STYLE=NORMAL,RIGHTGAP=0.00,LEFTGAP=0.00,$
TYPE=REPORT,COLUMN=P1 ,SQUEEZE=1.00,$
TYPE=REPORT,COLUMN=P2 ,SQUEEZE=1.00,$
TYPE=REPORT,COLUMN=P3 ,SQUEEZE=1.00,$
TYPE=REPORT,COLUMN=P4 ,SQUEEZE=0.75,$
TYPE=REPORT,COLUMN=P5 ,SQUEEZE=0.75,$
TYPE=REPORT,COLUMN=P6 ,SQUEEZE=0.75,$
TYPE=SUBFOOT,ITEM=1 ,JUSTIFY=LEFT  ,WIDTH=1.00,$
TYPE=SUBFOOT,ITEM=2 ,JUSTIFY=LEFT  ,WIDTH=0.75,$
TYPE=SUBFOOT,ITEM=3 ,JUSTIFY=LEFT  ,WIDTH=1.00,$
TYPE=SUBFOOT,ITEM=4 ,JUSTIFY=RIGHT ,WIDTH=1.75,STYLE=BOLD,COLOR='RED',$
ENDSTYLE
END

Thanks, that was what I was looking for.