Print Page - Report Output Change color of field based on certain condition

Title: Report Output Change color of field based on certain condition
Post by: nfldbunker on 14 Oct 2009 06:41:52 AM

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

Title: Re: Report Output Change color of field based on certain condition
Post by: rockytopmark on 14 Oct 2009 02:49:21 PM

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

Title: Re: Report Output Change color of field based on certain condition
Post by: dumbell on 17 Oct 2009 12:03:44 PM

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: nfldbunker on 14 Oct 2009 06:41:52 AM