Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Conditional formatting for similar across columns
Go
New
Search
Notify
Tools
Reply
  
[SOLVED]Conditional formatting for similar across columns
 Login/Join
 
Member
posted
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, 2011Reply With QuoteReport This Post
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: 1655 | Location: Enschede, Netherlands | Registered: August 12, 2010Reply With QuoteReport This Post
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, 2005Reply With QuoteReport This Post
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, 2011Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Conditional formatting for similar across columns

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.