COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: otsizh on 03 Oct 2005 02:03:49 PM

Title: [Solved]Value Prompt and Conditional Explorer
Post by: otsizh on 03 Oct 2005 02:03:49 PM
Hello,

Is it posible to create the value prompt with static choices only (Collection) for example:
Use ValÃ,  Ã,  Display
rÃ,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  red
gÃ,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, green
then, to create a Conditianal variable with conditional expresion:
if( ?Param1? = 'r') then 'Yes' else 'No'

that will change the baground of the list (if user will oick red the baground should be red, if green then green)

it is always dispays baground in 'green' color, it looks like the expressinon did not catch the papameter value.
Can anybody help?
Thank you
Title: Re: Value Prompt and Conditional Explorer
Post by: mallika on 03 Oct 2005 03:25:06 PM
yes it is possible. however your expression may not be correct. In the layout expression editor, select the parameters tab, this will list out all parameters. Drag the parameter that is associated with your prompt. If you create a boolean variable then your expression will be

ParamDisplayValue("Parameter1")='red'

Remember if your variable is of type Boolean then you need not use If ... else, any comparision operator like =, <, >  validates to true or false (yes or no).

Title: Re: Value Prompt and Conditional Explorer
Post by: otsizh on 03 Oct 2005 03:42:30 PM
THANK YOU VERY MUCH!!!!
Title: Re: [solved]Value Prompt and Conditional Explorer
Post by: COGNOiSe administrator on 03 Oct 2005 05:49:29 PM
otsizh, don't forget to click on the 'tick' symbol on the post that helped solve your problem. This helps others identify which topics have been solved and which post helped solve the question.

Thanks