[SOLVED]Conditional formatting for similar across columns

Hello,
I created the following report and need to apply conditional formatting depending on the value:
SUM
X
Y
BY Z
ACROSS YEAR

---------2011---2012---2013
Z--------X-Y----X-Y----X-Y
data1----p-g----p-g----p-g
data2----r-u----r-u----r-u
....

When i try to apply the formatting below output=HTML, i get the expected result, if i try output=AHTML this does not work. Any thoughts on how to make this work for ATHML?

TYPE=DATA, ACROSSCOLUMN=N1,
BACKCOLOR=RED, WHEN=X EQ 'P', $
TYPE=DATA, ACROSSCOLUMN=N1,
BACKCOLOR=YELLOW, WHEN=X EQ 'R', $

TYPE=DATA, ACROSSCOLUMN=N2,
BACKCOLOR=GREEN, WHEN=Y EQ 'G', $

TYPE=DATA, ACROSSCOLUMN=N2,
BACKCOLOR=LIME GREEN, WHEN=Y EQ 'U', $

This message has been edited. Last edited by: Daryl H.,

Daryl Hechanova
Systems Analyst
Fidelity Investments

WebFOCUS 7.6
Linux for x64 64 bit, All Outputs

Posts: 4 | Registered: June 21, 2011

Wep5622

Virtuoso

posted

Hide Post

Try with WHEN=N3 EQ ... instead of 'Y'.
In my experience using column names in ACROSS style-rules is unreliable at best.

WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :

Posts: 1669 | Location: Enschede, Netherlands | Registered: August 12, 2010

Ignored post by Wep5622 posted

Show Post

Francis Mariani

Expert

posted

Hide Post

This doesn't help you at all, but it may help someone to come up with a solution: provide an example using one of the sample tables - in this way, we can tweak the code until it works. I can't see a reason why the styling doesn't work for AHTML - it works for HTML, PDF, Excel 2000 and PowerPoint.

TABLE FILE GGSALES
SUM
DOLLARS
UNITS
BY REGION
BY ST
ACROSS PRODUCT

ON TABLE PCHOLD FORMAT HTML

ON TABLE SET STYLE *
TYPE=DATA, ACROSSCOLUMN=DOLLARS,
BACKCOLOR=RED, WHEN=DOLLARS LT 300000, $

TYPE=DATA, ACROSSCOLUMN=DOLLARS,
BACKCOLOR=YELLOW, WHEN=DOLLARS GT 300000, $

TYPE=DATA, ACROSSCOLUMN=UNITS,
BACKCOLOR=GREEN, WHEN=UNITS LT 30000, $

TYPE=DATA, ACROSSCOLUMN=UNITS,
BACKCOLOR=LIME GREEN, WHEN=UNITS GT 30000, $

END

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Show Post

Daryl H.

Member

posted

Hide Post

Thank you all for the responses.

Daryl Hechanova
Systems Analyst
Fidelity Investments

WebFOCUS 7.6
Linux for x64 64 bit, All Outputs

Posts: 4 | Registered: June 21, 2011

Ignored post by Daryl H. posted

Show Post