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     Conditional styling with ACROSS
Go
New
Search
Notify
Tools
Reply
  
Conditional styling with ACROSS
 Login/Join
 
Guru
posted
Hi all,

I want to add conditional styling on some data in my report. I have made this:
SUM
AVEAVEREVENUE NOPRINT
COMPANIES1C1 NOPRINT
PCT
COMPUTE CHECK/A1=IF (AVEAVEREVENUE GT 0) OR (COMPANIES1C1 GT 0) THEN 'Y' ELSE 'N';
BY BAND1 AS ''
ACROSS YEAR AS ''
TYPE=DATA,
     COLUMN=PCT,
     BORDER-TOP          = LIGHT,
     BORDER-BOTTOM       = LIGHT,
     BORDER-LEFT         = LIGHT,
     BORDER-RIGHT        = LIGHT,
     BORDER-TOP-STYLE    = RIDGE,
     BORDER-BOTTOM-STYLE = RIDGE,
     BORDER-LEFT-STYLE   = RIDGE,
     BORDER-RIGHT-STYLE  = RIDGE,
     BORDER-TOP-COLOR    = RGB(240 240 240),
     BORDER-BOTTOM-COLOR = RGB(240 240 240),
     BORDER-LEFT-COLOR   = RGB(240 240 240),
     BORDER-RIGHT-COLOR  = RGB(240 240 240),
     SIZE                = &L_FSIZE,
     COLOR               = 'BLACK',
     STYLE               = -UNDERLINE+BOLD,
     BACKCOLOR           = RGB(186 213 240),
     WHEN  		 = CHECK EQ 'Y',


This results in conditional styling for only the first ACROSS value. Is this a WF bug? Any tips on how I can get conditional styling on this data?


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 416 | Location: Europe | Registered: February 05, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Frans

instead of using


COLUMN=PCT,

Try

ACROSSCOLUMN=N3,




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Reply With QuoteReport This Post
Guru
posted Hide Post
Hi Frank,

it worked out this way:

ACROSSCOLUMN = PCT,

Thanks for the solution,

Frans


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 416 | Location: Europe | Registered: February 05, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Dat is mooi.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Conditional styling with ACROSS

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