I am trying to carry over the color background formatting to a multi year report with school_year as ACROSS. I have tried ACROSSVALUE and ACROSSCOLUMN but background colors will not display. Here is original code snipet N6=SPLACCOUNTABILITY A100V

TYPE=REPORT,
COLUMN=N6,
BACKCOLOR=RGB(0 161 224),
WHEN=N6 EQ 'Exceeding Expectations',
$
TYPE=REPORT,
COLUMN=N6,
BACKCOLOR=RGB(0 161 224),
WHEN=N6 EQ 'Exceeding Alternative School Expectations',
$
TYPE=REPORT,
COLUMN=N6,
BACKCOLOR='ORANGE',
WHEN=N6 EQ 'Not Meeting Expectations',
$
TYPE=REPORT,
COLUMN=N6,
BACKCOLOR='ORANGE',
WHEN=N6 EQ 'Not Meeting Alternative School Expectations',
$ This is a multi output report but mainly is HTML 8204 Webfocus version 3

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

Try using Conditional Formatting, AKA: Stop lighting, in the TYPE=DATA section?

The issue with that code is that column N6 will be reset and displayed with the attributes of the last reference to it. WebFOCUS is parsed / interpreted line by line.

Is that what you're looking for ?

DEFINE FILE GGSALES
DYR  /YY    = DATE;
DMTH /MONTH = DATE;
TEST /A1    = DECODE PRODUCT ('Coffee Pot' 'C' 'Latte' 'L' 'Mug' 'M');
END
TABLE FILE GGSALES
SUM DOLLARS
    TEST       NOPRINT
BY DMTH        AS 'Month'
ACROSS DYR     AS ''
ACROSS PRODUCT AS ''
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *

     DEFMACRO=DMAC_CPOT,
     MACTYPE=RULE,
     WHEN=TEST EQ 'C',
$
     DEFMACRO=DMAC_LATTE,
     MACTYPE=RULE,
     WHEN=TEST EQ 'L',
$
     DEFMACRO=DMAC_MUG,
     MACTYPE=RULE,
     WHEN=TEST EQ 'M',
$
TYPE=DATA,
     ACROSSCOLUMN=DOLLARS,
     BACKCOLOR=RGB(0 161 224),
     MACRO=DMAC_CPOT,
$
TYPE=DATA,
     ACROSSCOLUMN=DOLLARS,
     BACKCOLOR=RGB(0 161 224),
     MACRO=DMAC_LATTE,
$
TYPE=DATA,
     ACROSSCOLUMN=DOLLARS,
     BACKCOLOR='ORANGE',
     MACRO=DMAC_MUG,
$
ENDSTYLE
END