The list of values available for a parameter in a Print Preview can be filtered based on the current value of another parameter.
To filter the list of parameter values, click the ellipsis button in the Add New Parameter dialog window and specify a filter string that refers to another parameter.
Next, click the report's smart tag, and in the invoked actions list, click the ellipsis button in the Filter String property. In the invoked FilterString Editor, construct an expression that uses both parameters:
The following image illustrates cascading parameters, with the Product values filtered based on the selected Category.