Cross Tab Conditional Color Signalling (Red, Green, Yellow)

[kalyan_sekhar1]

Hi,

This is the weird problem i am facing while doing a Cross-Tab report. This is what i want to achieve in the Crosstab report

I would like to highlight the backgound color of a particular cell depending on the condition. For eg:

Consider two coloumns Salary and Commission, and i want to highlight the salary background color as red when Salary < Commission else Green

But we are getting only the false condition

Can any one please help me out on this

Thanks

[dummyhalf]

If you are applying conditional formatting for a particular column, try:

http://cognoise.com/community/index.php?topic=43.msg169#msg169

[JGirl]

Hi, have you resolved this issue yet?  If not, what do you have as the expression for the conditional varaible?  Have you created a test column in the query to ensure that your logic is being applied correctly?

I'm watching this posting with interest as I'm also having problems with applying conditional formatting to a crosstab for a particular condition....

[kalyan_sekhar1]

Hi

My issue of  crosstab is ,i need to apply colors based on two column condition.

i have an few attributes in my report like (month_value, target_vlue.....)
these two Month_Value and Target_Values are measurable attributes
my condition is
if the Month_Value  is gretertan Target_Value then background color green
if the Month_Value is lessthan Target_Value the  background color is Red

for this we created variable(we trye with boolean as well as string variable) and apply the conditions in conditional style properties. but the condition is not applicable it shows only one color,while we r applying color condition for one attributr like Month_Value>1000 then background color is Green and Month_Value<1000  then background color is Red.
this works fine. when we will try to apply the color condition with two attribute,it can not be applicable.

please anybody having an idea update me as soon as possible, its very urgent for me.

Thanx

[JGirl]

I was asking what EXACTLY is your report expression for the conditional variable? Is it something like
[Month Value] > [Target Value], or something different?

[addpremkumar]

Hi,

Exactly the same...

My Condition is,(String Variable)

CASE
WHEN [MONTH VAL] > [TARGET VALUE] THEN (0)
WHEN [MONTH VAL] = [TARGET VALUE] THEN (1)
WHEN [MONTH VAL] < [TARGET VALUE] THEN (2)
END

Where 0-Green , 1-Yellow , 2-Red
These  Background colors should be highlited...

Thanks In Advance...
Prem.

[kalyan_sekhar1]

Hi Jgirl,

Look into the condition that "addpremkumar" posted. He is one of my colleague so he posted the logic

Thanks

[kalyan_sekhar1]

Hi,

While looking into a forum i came across the article which says there is a bug in COGNOS MR1.0 or MR1.1, and the Crosstab issue is resolved in Cognos MR1.2, but still i guess its not resolved.

Have a look into the attached document.

Thanks