Hi All,

I have a across report ( Across by Country ) and i need to set background color to country names. And on across column I have the the data visualization on , if i remove the data visualization i am able to set the background color but with visualization it does not work , please advise

Sample code 1:-Across value Bg color works and don't have visualization

 -* File: IBFS:/localhost/WFC/Repository/Retail_Sample/Report1.fex Created by WebFOCUS AppStudio
TABLE FILE CAR
SUM
     CAR.BODY.SALES
     CAR.SPECS.BHP
     CAR.SPECS.WIDTH
     CAR.SPECS.HEIGHT
BY  CAR.COMP.CAR
ACROSS CAR.ORIGIN.COUNTRY
WHERE COUNTRY EQ 'ENGLAND' OR 'FRANCE' OR 'ITALY' ;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML

ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty,
$
TYPE=DATA,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     FONT='IBIDEFAULT',
     SIZE=9,
$
TYPE=TITLE,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     FONT='IBIDEFAULT',
     SIZE=11,
     STYLE=-UNDERLINE+BOLD,
$
TYPE=TABHEADING,
     SIZE=14,
     COLOR=RGB(75 75 75),
     STYLE=BOLD,
     JUSTIFY=CENTER,
$
TYPE=TABHEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     COLOR=RGB(153 153 153),
$
TYPE=ACROSSVALUE,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     SIZE=14,
     STYLE=BOLD,
     JUSTIFY=CENTER,
$
TYPE=ACROSSVALUE,
     COLUMN=N2,
     COLOR='WHITE',
     BACKCOLOR=RGB(102 102 170),
$
TYPE=ACROSSVALUE,
     COLUMN=N6,
     COLOR='WHITE',
     BACKCOLOR=RGB(51 204 204),
$
TYPE=ACROSSVALUE,
     COLUMN=N10,
     COLOR='WHITE',
     BACKCOLOR=RGB(80 60 255),
$

TYPE=ACROSSTITLE,
     COLOR='BLACK',
     STYLE=BOLD,
$
ENDSTYLE
END

Sample code 2:- Across value Bg color does not works with visualization and I needed the background color with visualization

 TABLE FILE CAR
SUM
     CAR.BODY.SALES
     CAR.SPECS.BHP
     CAR.SPECS.WIDTH
     CAR.SPECS.HEIGHT
BY  CAR.COMP.CAR
ACROSS CAR.ORIGIN.COUNTRY
WHERE COUNTRY EQ 'ENGLAND' OR 'FRANCE' OR 'ITALY' ;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML

ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty,
$
     DEFMACRO=COND0001,
     MACTYPE=RULE,
     WHEN=N4 LT 0,
$

TYPE=REPORT,
$
     GRAPHTYPE=DATA,
     ACROSSCOLUMN=N4,
     GRAPHCOLOR='BLUE',
$
     GRAPHTYPE=DATA,
     ACROSSCOLUMN=N4,
     GRAPHCOLOR='RED',
     MACRO=COND0001,
$
TYPE=DATA,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     FONT='IBIDEFAULT',
     SIZE=9,
$
TYPE=TITLE,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     FONT='IBIDEFAULT',
     SIZE=11,
     STYLE=-UNDERLINE+BOLD,
$
TYPE=TABHEADING,
     SIZE=14,
     COLOR=RGB(75 75 75),
     STYLE=BOLD,
     JUSTIFY=CENTER,
$
TYPE=TABHEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     COLOR=RGB(153 153 153),
$
TYPE=ACROSSVALUE,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     SIZE=14,
     STYLE=BOLD,
     JUSTIFY=CENTER,
$
TYPE=ACROSSVALUE,
     COLUMN=N2,
     COLOR='WHITE',
     BACKCOLOR=RGB(102 102 170),
$
TYPE=ACROSSVALUE,
     COLUMN=N6,
     COLOR='WHITE',
     BACKCOLOR=RGB(51 204 204),
$
TYPE=ACROSSVALUE,
     COLUMN=N10,
     COLOR='WHITE',
     BACKCOLOR=RGB(80 60 255),
$

TYPE=ACROSSTITLE,
     COLOR='BLACK',
     STYLE=BOLD,
$
ENDSTYLE
END
 

This message has been edited. Last edited by: Chaudhary,

Try:

...
TYPE=ACROSSVALUE,
     COLOR='WHITE',
     BACKCOLOR=RGB(102 102 170),
     WHEN=COUNTRY EQ 'ENGLAND',
$
TYPE=ACROSSVALUE,
     COLOR='WHITE',
     BACKCOLOR=RGB(51 204 204),
     WHEN=COUNTRY EQ 'FRANCE',
$
TYPE=ACROSSVALUE,
     COLOR='WHITE',
     BACKCOLOR=RGB(80 60 255),
     WHEN=COUNTRY EQ 'ITALY',
$
...

Thanks Francis, It works