COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Jennyw on 27 Aug 2014 01:51:50 PM

Title: How to use 'Conditional display values' in static choices value prompt
Post by: Jennyw on 27 Aug 2014 01:51:50 PM
Hi all,
i created a static choices value prompt(multi-select, no query attached),  with values 1 to 9, would like to have a conditional string variable to display values conditionally.

i made a conditional variable string1 (click the static choices in a prompt),
with expression definition: if ((ParamDisplayValue("SLES")) contains 'Female') then  ('1') else ('2'),
'1' has  a group of values (1,2,3,4,5,6,7,8,9)
'2' has a group of values (1,2,3,4,5)

a Boolean variable uses those values to control which page to display to the user.

What's wrong with my codes, it did not work.
How to achieve my goal?

Thanks for any help.

Jenny
Title: Re: How to use 'Conditional display values' in static choices value prompt
Post by: bdbits on 27 Aug 2014 04:36:40 PM
This sounds the same as your post earlier this year, for which you had the solution. Is this somehow different?

http://www.cognoise.com/index.php/topic,24306.msg76075.html#msg76075 (http://www.cognoise.com/index.php/topic,24306.msg76075.html#msg76075)


Title: Re: How to use 'Conditional display values' in static choices value prompt
Post by: Jennyw on 28 Aug 2014 08:40:51 AM
it's a different one,  i DO use that tech. for the last step: to print  selected page(s) based on the prompt selection(multi-select).
this question is about to conditional display a set of values in a static choice value prompt: based on a selection of another prompt.

(//)