I'm sure this is an easy question, but I'm not having any luck figuring it out.

In the following code, how would you identify the description portion of the subtotal (country, so England, W Germany....) so that you can change the font size of just the description but not the numbers?

TABLE FILE CAR
SUM
SALES AS 'SALES,FOR THIS,YEAR'
RETAIL_COST AS 'RETAIL,COST'
DEALER_COST AS 'DEALER,COST'
BY COUNTRY NOPRINT
BY BODYTYPE NOPRINT
BY MODEL
ON COUNTRY SUBHEAD
"<COUNTRY "
ON BODYTYPE SUBHEAD
"<BODYTYPE "
ON COUNTRY SUBTOTAL AS ''
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLESHEET *
TYPE = REPORT, FONT=ARIAL, SIZE=9, SQUEEZE=ON, ORIENTATION=LANDSCAPE,$
TYPE=TITLE, COLUMN=SALES, BORDER-BOTTOM=ON,$
TYPE=SUBTOTAL, BY=1, COLOR=RED, $
ENDSTYLE
END

Thanks!
Bethany

I would like to know if there is an easier way to do this but, I found if you set the entire subtotal to the desired size for the description portion and then set the size for the number columns separately, I get the result I'm looking for.

TYPE=SUBTOTAL, BY=1, SIZE=10, $
TYPE=SUBTOTAL, BY=1, COLUMN=SALES, SIZE=20, $
TYPE=SUBTOTAL, BY=1, COLUMN=RETAIL_COST, SIZE=20, $
TYPE=SUBTOTAL, BY=1, COLUMN=DEALER_COST, SIZE=20, $

Bethany

Bethany,

That's pretty much the only way I know of to do this.

See my post in the following thread for a bit more insight into this issue. Susannah asked this very same question not too long ago.

https://forums.informationbuilders.com/eve/forums/a/tpc/...731044792#2731044792

As Mickey states, there really isn't a way to separate the components of a SUBTOTAL line, but you can specify separate styling of individual columns, as you have done. The label (AS ''[fieldname]) is not a separately identifiable item. It may be easier to use ON COUNTRY SUBFOOT, embedding fields and subtotals, which are then separately identifiable with the ITEM=.

All you actually need is

TYPE=SUBTOTAL, BY=1, SIZE=10, $
TYPE=SUBTOTAL, BY=1, COLUMN=c*, SIZE=20, $

this will style all data columns

Same concept as before but at least you don't have to specify individual columns. Great idea - this would be quicker than the SUBFOOT and field placement is still automatic.