Hi,
I would like to customize styling for the last column, as this is row totals on across and using over
here is my code

 TABLE FILE SQLOUT
SUM
GT99/I5 AS '' OVER
90TO99/I5 AS '' OVER
80TO89/I5 AS '' OVER
70TO79/I5 AS '' OVER
LT70/I5 AS '' OVER
NA/I5 AS ''
ACROSS PID AS ''
ACROSS-TOTAL AS '&REPORT_TO'
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET PAGE NOPAGE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
	PAGESIZE='Letter',
	ORIENTATION=LANDSCAPE,
	LEFTMARGIN=0.3,
	WRAP=OFF,
$

TYPE=ACROSSVALUE,COLUMN='&REPORT_TO',BY=SPKADET,FONT='ARIAL',BACKCOLOR='RED',STYLE=BOLD,$


 

Please let me know how to customize my last column as this column is row totals

This message has been edited. Last edited by: Krishna.edara,

In WebFOCUS 8.0.08, I feel the documentation is very vague about styling the ACROSS-TOTAL component. I cannot find any details.

Changing the code from ACROSS-TOTAL to ROW-TOTAL allows for this:

TABLE FILE CAR
SUM
SALES AS '' OVER
WEIGHT AS '' OVER
LENGTH AS '' OVER
HEIGHT AS ''
ACROSS COUNTRY AS ''
-*ACROSS-TOTAL AS 'ACROSS TOTAL'
ON TABLE ROW-TOTAL AS 'ROW TOTAL'
ON TABLE SET STYLE *
TYPE=DATA,COLUMN=ROWTOTAL(*),COLOR=GREEN,
ENDSTYLE
END

Thank you Francis,
It worked half way, can I change the Column heading color for total also ?

Thanks,

I think it should be the following, but it doesn't work:

TYPE=TITLE, COLUMN=ROWTOTAL, COLOR=BLUE, $

This does work:

TYPE=REPORT, COLUMN=ROWTOTAL, COLOR=BLUE, $

but it also affects the row total value for the first row.

When used in conjunction with the data styling, it works:

TYPE=REPORT, COLUMN=ROWTOTAL, COLOR=BLUE,$
TYPE=DATA, COLUMN=ROWTOTAL(*), COLOR=GREEN, $

Thanks Francis,

It worked the way I want.

Thanks.