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

How to apply Conditional Style to Prompt Values

Started by dsg1, 02 Feb 2012 07:25:31 AM

Previous topic - Next topic

dsg1

Hi,

I have a report which shows : Product_Line, Revenue, Status

Status : calculated on revenue
(case
when [Revenue] <= 100000000  then ('red')
when [Revenue] >= 1000000000 then ('blue')
else ('green')
end)

I have a value prompt (drop down list) in the report page which gives me the option to choose my Product_Line (parameter 'PL').

These Product_Line prompt values should be displayed as red/blue/green (font colur) based on the status condition.....when the users click on the drop down list.

Is there a way I can achieve this in Cognos?

Thanks
dsg