COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Chandrasekar on 25 Sep 2014 08:43:57 AM

Title: Cumulative Prompt selection
Post by: Chandrasekar on 25 Sep 2014 08:43:57 AM
Hi Gurus,

I have one requirement, In prompt page have 3 value prompts.
For ex: pval_productline(single select), pval_producttype(multiselect) and pval_product(multiselect).

Condition is,
1. First pval_productline prompt only shows in prompt page.
2. After selecting the prompt value the second prompt will displayed in prompt page.
3.Same as another prompt.

How to solve this? Please suggest your valuable thoughts.

Thanks & Regards,
Chandrasekar.

Title: Re: Cumulative Prompt selection
Post by: esar on 25 Sep 2014 12:49:23 PM
use reder variables to render the 2nd and 3rd prompt based on prior prompt selection
Title: Re: Cumulative Prompt selection
Post by: Chandrasekar on 25 Sep 2014 10:04:17 PM
Hi Easr,

Thanks for your reply, I create to Boolean variable. One is ParamDisplayValue('?pval_productline?'), another one is ParamDisplayValue('?pval_producttype?').

In prompt page create two blocks. First prompt placed in table. 2nd & 3rd prompt placed in block.
2nd prompt have ParamDisplayValue('?pval_productline?') Boolean variable and 3rd prompt have ParamDisplayValue('?pval_producttype?') Boolean variable.

After run i see first prompt only. How to solve this?

Thanks & Regards,
Chandrasekar.
Title: Re: Cumulative Prompt selection
Post by: MFGF on 30 Sep 2014 06:49:42 AM
If I was writing the report, I would put the prompts on separate prompt pages.

MF.
Title: Re: Cumulative Prompt selection
Post by: Chandrasekar on 30 Sep 2014 06:52:54 AM
Hi MFGF,

Finally i got the answer in two ways.
One is, What you suggest
Another one is Create boolean variable for 2nd and 3rd prompt
       ParamDisplayValue(?parameter? is not null) OR ParamDisplayValue(?parameter? is not missing)
it works.

Thanks and Regards,
Chandrasekar.