Report Studio

Create a cascading prompt to use values from one prompt to filter values in another prompt. For example, a report contains the columns Product line and Product type. You create prompts for these columns, and you specify that the Product type prompt is a cascading prompt that uses Product line as the cascading source. When users select a product line, they see only the product types related to the selected product line.

To Create a Cascading Prompt:

1. To make the cascading source a required prompt, click it and in the Properties pane, set the Required property to Yes.
2. Click the prompt control that you want to use as a cascading prompt.
3. In the Properties pane, double-click the Cascade Source property.
4. Click the parameter that represents the cascade source, and click OK.
5. If the prompt allows users to select multiple values, add a prompt button to the cascade source to provide the cascading prompt with the appropriate values:
6. From the Toolbox tab, drag Prompt Button to the report.
7. Click the prompt button and in the Properties pane, click the Type property and click Reprompt.
8. To change the text in the prompt button, in the Insertable Objects pane, on the Toolbox tab, drag Text Item to the prompt button and type the text.

Related Topics:

• Modifying Prompts—Ways you can modify your prompts.
• Change the Prompt Control Interface—How to change the prompt control interface.
• Specify that a Prompt Requires User Input—How to specify that a prompt is required.
• Specify Default Selections—How to specify the default selections for prompts.

Copyright © 2018 Daptiv Solutions, LLC. All Rights Reserved