COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: kvin on 28 May 2009 05:00:42 AM

Title: Changing Cell Background color by condition
Post by: kvin on 28 May 2009 05:00:42 AM
Hi,
I've 2 measure column in the C8 Web report. Here i need to show the column1 cell's value background as color red when it exceed the value of column2. So how i can achieve it? Thanks in advance.
Title: Re: Changing Cell Background color by condition
Post by: S_N_Solution on 28 May 2009 05:26:12 AM
Hi,

Define a boolean variable and give condition as Column1 > Column2.
then select the column 1 & set for variable value Yes the style variable as boolean and in property background colour as Red.
This will work...
Title: Re: Changing Cell Background color by condition
Post by: Gollapudi on 28 May 2009 06:19:58 AM
We have conditional explorer to do all this kind of Data hilighting, just go through the Report Studio user guice, we can make lot many miracles with conditional formating..
Title: Re: Changing Cell Background color by condition
Post by: vij on 28 May 2009 07:46:19 AM
HI Kvin ,

in your report take Boolean varibale and in it put condiotion as column1>column 2
and then click on YES value and select that Boolean variable and set Background Color to RED to the Column Body Style.
and Run the Report,

hope it wil helps u ..........



vij