TABLE FILE CAR
SUM
RETAIL
BY COUNTRY
ACROSS CAR

END

Using the car table, I am trying to make the font a different color depending on it's value (RETAIL GT 10000). I have tried both the DEFMACRO and TYPE=ACROSSVALUE with a WHEN=RETAIL GT 10000. Can this be done. I think I may have read something that indicated it can't be.

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

Maybe this could work for you:

 
SET ACROSSTITLE = SIDE
TABLE FILE CAR
SUM
     SALES
BY  LOWEST COUNTRY
ACROSS LOWEST SEATS
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
 include=endeflt, $
type=report, border=light, $
TYPE=DATA,
     ACROSSCOLUMN=SALES, color=red, 
	 WHEN=SALES GT 10000,
$
ENDSTYLE
END
 

FYI :

TYPE=ACROSSTITLE is for the title displayed above the across field

TYPE=ACROSSVALUE is for the across field itself

TYPE=DATA, ACROSSCOLUMN=colABC is for the SUM/PRINT data that lays under the across field

TYPE=DATA, COLUMN=colABC(*) is for the SUM/PRINT data that lays under the across field

Sometime, the above may replace the ACROSSCOLUMN=ColABC to style the data and works where ACROSSCOLUMN doesn't. Never been able to figure why

That worked thank you