Cumulative Prompt selection

[Chandrasekar]

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.

[esar]

use reder variables to render the 2nd and 3rd prompt based on prior prompt selection

[Chandrasekar]

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.

[MFGF]

If I was writing the report, I would put the prompts on separate prompt pages.

MF.

[Chandrasekar]

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.