[SOLVED]Condtional Styling?

May 27, 2011, 11:21 AM

Charles Richards

I would like to conditional styleing to a column so that if the value in the field is negative to shows up red and if not it continues its normal pattern of alturnating between white and blue

I tried to use conditional styleing under options, however it seems to color the whole column red instead of just the individual values.

Thanks for the Help!

This message has been edited. Last edited by: Charles Richards,

May 27, 2011, 01:13 PM

ABT

SET SQUEEZE = ON;

TABLE FILE CAR
PRINT
	COUNTRY 
	CAR 
	MODEL 
	BODYTYPE 
	WARRANTY 
	STANDARD 
	SEATS

ON TABLE PCHOLD FORMAT PDF
ON TABLE SET PAGE-NUM OFF
ON TABLE SET HTMLCSS ON

ON TABLE SET STYLE *
     UNITS=IN,
     PAGESIZE='Letter',
     LEFTMARGIN=0.250000,
     RIGHTMARGIN=0.000000,
     TOPMARGIN=0.250000,
     BOTTOMMARGIN=0.250000,
     SQUEEZE=OFF,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=10,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     LEFTGAP=0.05,
     RIGHTGAP=0.05,
	 SQUEEZE=ON,
$
TYPE=DATA,
     COLUMN=N1,
     COLOR='BLACK',
     BACKCOLOR='YELLOW',
$
TYPE=DATA,
     COLUMN=N1,
     COLOR='WHITE',
     BACKCOLOR='RED',
     WHEN = N1 EQ 'JAPAN',
$
ENDSTYLE
END

This may be a first for me to say (ever), but a lot of the general use topics are covered in the Creating Reports with the WebFOCUS Language e-book.

- ABT

------------------------------------
WF Environment:
------------------------------------
Server/Client, ReportCaster, Dev Studio: 7.6.11
Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist
OS: Windows Server 2003
Application/Web Server: Tomcat 5.5.25
Java: JDK 1.6.0_03
Authentication: LDAP, MRREALM Driver
Output: PDF, EXL2K, HTM

------------------------------------
Databases:
------------------------------------
Oracle 10g
DB2 (AS/400)
MSSQL Server 2005
Access/FoxPro