cascading prompt issue

[mntowe]

Hello all,
I have an issue in report studio where I do have a cascading prompt with 3 value prompts. I'd like to hide the second prompt but auto select everything from that second prompt and base the third prompt from that autoselect. I've tried join and intersect but without success. I'm using report studio 8.4. Any suggestion on how to proceed on this? Thank you.

[cschnu]

Hello all,
I have an issue in report studio where I do have a cascading prompt with 3 value prompts. I'd like to hide the second prompt but auto select everything from that second prompt and base the third prompt from that autoselect. I've tried join and intersect but without success. I'm using report studio 8.4. Any suggestion on how to proceed on this? Thank you.

If you want to select everything from the second prompt then you should just be able to filter your third prompt based on the 1st prompt and really not need a 2nd prompt. A prompt is a query so you should be able to add filters into your prompt query