If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Report Output Change color of field based on certain condition

Started by nfldbunker, 14 Oct 2009 06:41:52 AM

Previous topic - Next topic

nfldbunker

hi

I have a list report which i want to spruce up a bit and have certain Length of stay output fields have different color if they are over a cetain number.

example
LOS
10
29
3
25
40
report ouput would be green or red if LOS days are over  25

thanks

bunker

rockytopmark

Create a variable, boolean type, with an expression like:
[LOS] > 25

Then assign this variable to the Style Variable of the object you want to conditionally color.
Set the Variable's condition to True, color the object's background Red
Set the Variable's condition to False, color the object's background Green

dumbell

I see conditonal styling in 8.3.
It works like a charm.