If you are unable to create a new account, please email support@bspsoftware.com

 

Render Variable on a cascading prompt based on a static prompt value

Started by cognos2014, 25 Mar 2016 02:45:21 PM

Previous topic - Next topic

cognos2014

Hi Gurus,

So my report has 3 prompts
Prompt 1:Static choices
Prompt 2: Table 1
Prompt 3: Table 2 (cascading on table 1)

My requirement is based on what's chosen in prompt 1 (example lets say 1), prompt 3 has to be displayed. I have used a render variable to hide prompt 3 when prompt 1 <>1. This works fine the first time I select the prompts. But if I change the value in prompt 1 to say 2, it should display prompt 3 values. But this doesn't happen because prompt 3 is cascading from prompt 2.

Is there any way to achieve this with only 1 prompt page?

Thank You!

cognos2014

Update: I was able to solve this by adding a dummy invisible prompt below prompt 1 and set it to cascade on prompt 1. So everytime my prompt 1 value changes, the page is refreshed.