<< Click to Display Table of Contents >>

 

You can create cascading parameters to filter a list of predefined parameter values based on values in another parameter.

Cascading parameters example

Tip

Refer to the following topics for information on how to create a list of predefined parameter values:

Report Parameters with Predefined Static Values

Report Parameters with Predefined Dynamic Values

Follow the steps below to create cascading parameters in the Report Designer:

1.Create a report parameter you want to use to filter values of another parameter.

Create category parameter

2.Create a report parameter whose values you want to filter. Click the Filter String property's ellipsis button in the Add New Parameter dialog and specify a filter string that references the parameter you created in the first step.

Create products parameter

Note

In a filter string for a parameter's look-up values, you can reference only those parameters that you created before the parameter whose look-up values you want to filter. You can use the Report Parameters Editor to change the order in which you created the parameters. To invoke the editor, right-click the Parameters node in the Field List and select Edit Parameters.

3.In the report's smart tag, click the Filter String property's ellipsis button. In the invoked FilterString Editor, specify an expression that uses both parameters to filter report data:

Create a filter condition for a report

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

Cascading parameters example