Cascading Prompts

[dys]

My Report Studio report has a single prompt page with two value prompts, one cascading to the other (e.g. like the sample data Product Line cascading to Product Types for the selected Product Line). My problem is that when the prompt page opens, I'd like both prompts to be fully populated (e.g. all Product Lines and all Product Types), and then when I select a Product Line, the second prompt is re-populated with just the Product Types for the selected Product Line. Where I can then select one or more Product Types and the report is run with those selections.
Any help would be much appreciated :)

[BigChris]

I wouldn't have thought that was possible (please correct me if I'm wrong). For the cascading to work it needs the value from the first prompt.

You could achieve something like the effect you want by having an optional prompt on the source for the second prompt and adding a reprompt button that the user would need to click after selecting a value from the first prompt.

[dys]

Thanks BigChris. I was hoping to be able to somehow temporarily override the "cascade source" property of the second prompt and let the query of the second prompt bring all values forward first - while the parameter of the first prompt is still null (nothing yet selected). Then when the first prompt is selected and its parameter populated, re-run the second query to narrow the selections in the second prompt. Looks like I'll have to achieve it with some Javascripting.

[bdbits]

I do not really understand why you want to do this if the cascade is going to rerun the secondary query anyway? What are you trying to accomplish?

[dys]

I'm trying to accomplish user satisfaction :) The report user wants to have a choice of first seeing all possible selections in the second prompt, before deciding whether or not to narrow it down with a cascaded value from the first prompt. After applying reasoning, cajoling, arguing, and other means of gentle persuasion, I've concluded that the customer is always right. And I'm trying to make it right for the customer. So my effort continues...

[navissar]

I think my solution does that - but requires some setup. You can see it here http://www.ibm.com/developerworks/library/ba-pp-reporting-scripting_techniques-page673/

[dys]

Thanks for the link! I saw your article a while back, but initially discounted it as a possible solution. I'm going to re-visit it to see if it will satisfy the client's requirements. Thanks again :)

[venkatesham2132]

I think we can achieve by setting a property prepopulate of the prompt set to yes by default it is no so set it to yes try this

Sent from my GT-N8000 using Tapatalk