March 30, 2006, 04:20 PM
PrarieSubtotal styling
I have a Report that is supposed to be summed across months...and if the amount is LT 0 make it Red. I have the amounts working in the content of the report and in the row totals...but in the subtotal...no matter what the first amount is...it remains that color.
If it is positive...they will all be Black..if it is negitive all Red. Here's the code...and I've tried every variation, including naming the columns=n1 n2 ...but the Subtotal is not behaving.
TABLE FILE HADIT
SUM
AMT AS ' '
BY AREA NOPRINT
BY AREAM AS ' ' SUBTOTAL
BY
STAKA AS 'UNIT'
ACROSS
MTHYR AS ' ' AND ROW-TOTAL
ON TABLE SET STYLE *
TYPE=DATA,COLOR='RED',ACROSSCOLUMN=N1,WHEN=AMT LT 0, $
TYPE=DATA,COLUMN=ROWTOTAL(*),COLOR='RED',WHEN=ROWTOTAL LT 0,$
TYPE=SUBTOTAL,COLUMN=AMT(*),COLOR='RED',WHEN=AMT LT 0,$
 | In Focus since 1993. WebFOCUS 7.7.03 Win 2003 |
March 30, 2006, 04:50 PM
Kameshtry this,
TYPE=SUBTOTAL, BY=AREAM, COLOR=RED,WHEN=AMT LT 0,$
WFConsultant
WF 8105M on Win7/Tomcat
March 30, 2006, 04:58 PM
PrarieOhhhh...That sounded real promising...but no..still colors on what the first amount is...I'm sure it's the across that is doing this...
| In Focus since 1993. WebFOCUS 7.7.03 Win 2003 |
March 30, 2006, 06:19 PM
PrarieWell I thought I had tried this..but this works
TYPE=SUBTOTAL, COLOR=RED,ACROSSCOLUMN=N1, WHEN=AMT LT 0,$
| In Focus since 1993. WebFOCUS 7.7.03 Win 2003 |