October 03, 2013, 10:01 AM
RobertFFORMAT SUBTOTAL LINE
I am sure this is an easy one but it escapes me. How do I format my subtotal line to be a different color. It seams if I click one of the subtotals, then all aprear to get selected (you see a box around them all)..BUT...when I go to change the font color, if anything, it applies it to a random column!
Also, is there any way to add vertical grid lines?
What am I doing wrong?
October 04, 2013, 02:01 AM
MichaelBallePlease send your format code as TABLE FILE CAR example.
October 04, 2013, 04:20 PM
RobertFwhen timme allows I will wip something up...I thought it was as simple as selecting the Subtoal rows and clicking the desired format...guess not!
October 04, 2013, 04:32 PM
RobertFok, here is the code. What do I click etc to get the subtotal rows to be green. If I click any subtotal, they all light up but any formating only applies to the last *field* selected or the entire sheet if none were.
TABLE FILE CAR
SUM CAR.BODY.SALES
BY CAR.COMP.CAR SUBTOTAL
BY CAR.CARREC.MODEL
ON TABLE PCHOLD FORMAT HTML
ON TABLE RECOMPUTE
ON TABLE ROW-TOTAL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET STYLE *
INCLUDE=IBFS:/CFG/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, ORIENTATION=PORTRAIT, $
ENDSTYLE
END
-RUN
{status:'SUCCESS',hasstatus:true,exception:[]}