Hi,

I need to color the negative values as red in a report having BY and Across

Please help,
Type=data,color=red, when =n1 lt 0, $ is not working

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

Try something like this

TYPE=DATA,
COLUMN = N1,
WHEN= N1 LT 0,
COLOR='RED',
$

quote:

WHEN= N1 LT 0,
COLOR='RED',

Thanks for your reply Rao. It is working for the first column but not for the rest. Is it because I am using Across.

TABLE FILE SQLOUT1
SUM ABC
BY DEF
ACROSS XYZ
ACROSS KLD
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE
TYPE=DATA,COLUMN=N3,WHEN= N3 LT 0,COLOR='RED',$
ENDSTYLE
END

It's an ACROSS, so you have to use ACROSSCOLUMN:

TYPE=DATA      , ACROSSCOLUMN=AMOUNT_PC, COLOR=RED, WHEN=AMOUNT_PC LT 0, $
TYPE=SUBTOTAL  , ACROSSCOLUMN=AMOUNT_PC, COLOR=RED, WHEN=AMOUNT_PC LT 0, $
TYPE=GRANDTOTAL, ACROSSCOLUMN=AMOUNT_PC, COLOR=RED, WHEN=AMOUNT_PC LT 0, $

quote:

TYPE=DATA , ACROSSCOLUMN=AMOUNT_PC, COLOR=RED, WHEN=AMOUNT_PC LT 0, $

Thanks you very much Francis. You made my day.

Regards,
Sourabh