COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Mita on 30 Mar 2016 02:43:43 AM

Title: Dynamic Prompt value depending on another multiselect prompt
Post by: Mita on 30 Mar 2016 02:43:43 AM
Hi All,

Could any body suggest is it possible to achieve the below scenario.

The prompt page has one check box prompt where user can select single or more than one value.
The same page has some text box prompts which should appear depending on the value selected in the 1st checkbox prompt.

I can do this by conditional block and style valriable but that is applicable to single values in the 1st prompt.

Ex:Suppose I am selecting a category as Energy in the 1st check box then I can see only one text box prompt .
If I am selecting two values in the checkbox prompt ,I should have two text box prompts .
My 1st check box prompt has 5 values.

Is it possible?Can any one suggest some thing on this.

Regards,
Sasmita

Title: Re: Dynamic Prompt value depending on another multiselect prompt
Post by: Lynn on 30 Mar 2016 03:25:16 AM
Create a render variable for each of the text box prompts using the "contains" operator. The below Boolean expression will be true if the Energy option is selected even if other options are also selected. You'd have one of these Boolean variables defined for each of the text box prompts to be conditionally rendered. Just put each one as the render variable on the appropriate prompt control.

You'd need to put the check box prompts on a second prompt page or else include a re-prompt button on the first page.


ParamDisplayValue('CheckBoxParam') contains 'Energy'

Title: Re: Dynamic Prompt value depending on another multiselect prompt
Post by: Mita on 31 Mar 2016 12:45:53 AM
Thanks a lot Lynn...It worked..:) :)