Hi

how to apply styling on ACROSS-TOTAL , i want Backcolor on Total ,


I'm not able to apply color to "Total"
Please help me , this is sample code on car file

 SET ACROSSTITLE=SIDE
TABLE FILE CAR
SUM SEATS AS 'SEATS'
OVER RETAIL_COST AS 'RETAIL_COST'
OVER DEALER_COST  AS 'DEALER_COST'
ACROSS COUNTRY AS 'Country name'
ACROSS-TOTAL
ON TABLE SET PAGE NOLEAD
ON TABLE SET PAGE-NUM OFF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
$
TYPE=GRANDTOTAL,
BACKCOLOR=YELLOW,
STYLE=BOLD,
$
ENDSTYLE
END
 

This message has been edited. Last edited by: FP Mod Chuck,

Count the columns and cells, when using OVER:

  
SET ACROSSTITLE=SIDE
TABLE FILE CAR
SUM SEATS AS 'SEATS'
OVER RETAIL_COST AS 'RETAIL_COST'
OVER DEALER_COST  AS 'DEALER_COST'
ACROSS COUNTRY AS 'Country name'
ACROSS-TOTAL
ON TABLE SET PAGE NOLEAD
ON TABLE SET PAGE-NUM OFF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=ACROSSVALUE, COLUMN=N16, STYLE=BOLD, BACKCOLOR=YELLOW, $ 
ENDSTYLE
END
-EXIT

How to identify column=N16

In my report values are dynamic value(ACROSS values )

Row values is : 14(dynamic value)
column values :57 (Column Title) is default

SET ACROSSTITLE=SIDE
TABLE FILE CAR
SUM SEATS AS 'SEATS'
OVER RETAIL_COST AS 'RETAIL_COST'
OVER DEALER_COST AS 'DEALER_COST'
ACROSS COUNTRY AS 'Country name'
ACROSS-TOTAL
ON TABLE SET PAGE NOLEAD
ON TABLE SET PAGE-NUM OFF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=ACROSSVALUE, COLUMN=N16, STYLE=BOLD, BACKCOLOR=YELLOW, $
TYPE=DATA, COLUMN=N16, STYLE=BOLD, BACKCOLOR=YELLOW, $
TYPE=DATA, COLUMN=N17, STYLE=BOLD, BACKCOLOR=YELLOW, $
TYPE=DATA, COLUMN=N18, STYLE=BOLD, BACKCOLOR=YELLOW, $
ENDSTYLE
END

1. Open the manual, it's very helpful and enlightening!
2. Use ROW-TOTAL instead of ACROSS-TOTAL

  
SET ACROSSTITLE=SIDE
TABLE FILE CAR
SUM SEATS AS 'SEATS'
OVER RETAIL_COST AS 'RETAIL_COST'
OVER DEALER_COST  AS 'DEALER_COST'
ACROSS COUNTRY AS 'Country name'
ROW-TOTAL
ON TABLE SET PAGE NOLEAD
ON TABLE SET PAGE-NUM OFF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=ACROSSVALUE, COLUMN=ROWTOTAL(1), STYLE=BOLD, BACKCOLOR=YELLOW, $ 
TYPE=DATA, COLUMN=ROWTOTAL(*), STYLE=BOLD, BACKCOLOR=YELLOW, $ 
ENDSTYLE
END
-EXIT

This message has been edited. Last edited by: Tom Flynn,