Focal Point
Conditional styling with ACROSS

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6771010142

August 09, 2007, 03:20 AM
Frans
Conditional styling with ACROSS
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.
August 09, 2007, 04:21 AM
FrankDutch
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

August 09, 2007, 05:05 AM
Frans
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.
August 09, 2007, 05:18 AM
FrankDutch
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