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!
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.