All docs
V21.1
21.1
20.2
20.1
19.2
The page you are viewing does not exist in version 19.2. This link will take you to the root page.
19.1
The page you are viewing does not exist in version 19.1. This link will take you to the root page.
18.2
The page you are viewing does not exist in version 18.2. This link will take you to the root page.
18.1
The page you are viewing does not exist in version 18.1. This link will take you to the root page.
17.2
The page you are viewing does not exist in version 17.2. This link will take you to the root page.

Cascading Report Parameters

You can filter the list of predefined parameter values by another parameter’s value to create cascading parameters.

TIP

See the following topics for information on how to specify a predefined list of parameter values:

In a Report Designer, follow the steps below to filter the list of parameter values by another parameter’s value.

  1. Click the Filter String property’s ellipsis button in the Add New Parameter dialog and specify a filter string that refers to another parameter.

    CreatingProductCascadingParameter

  2. In the report’s smart tag, click the FilterString property’s ellipsis button. In the invoked FilterString Editor, specify an expression that uses both parameters:

    FilteringReportByTwoParameters

The following image illustrates cascading parameters where the Product parameter values are filtered by the selected Category.

CascadingParametersResult