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.

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:
    • Click the Toolbox icon The toolbox icon, 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, click the Toolbox icon, drag the Text item icon text item object icon to the prompt button and type the text.