Create a Cascading Prompt

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 source. When users select a product line, they see only the product types related to the selected product line.
Tip: The Employee Training by Year sample report in the GO Data Warehouse (analysis) package includes cascading prompts. For more information about The Sample Outdoors Company samples, see Sample Reports and Packages.

Procedure

  1. To make the cascading source a required prompt, select it and, in the Properties pane, set the Required property to Yes.
  2. Click the prompt control 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.
  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:
    • From the Toolbox tab toolbox tab, drag Prompt Button prompt icon to the report.
    • Click the prompt button and, in the Properties pane, set the Type property to Reprompt.
    • To change the text in the prompt button, on the Toolbox tab, drag Text Item text item object icon to the prompt button and type the text.
Parent topic: Modifying Prompts