Cascading Parameters
In some cases, it is desirable to have the user select a high-level category, in order
to limit the number of parameter choices a user sees. For example, let's say we were
looking at a report where a user needed to look at Products. In the case of a large
company, there could be thousands of possible Products or Product Codes. It may
be better to filter down based on a product line, to find the actual products you are
looking for. Using the Classic Cars example, we have many different types of car
models, such as the 1969 Harley Davidson Ultimate Chopper, Dodge Charger, and
1948 Porsche 356-A Roadster. If we want to limit what is displayed, we limit our
parameter display by product lines, such as Classic Cars, Motorcycles, or Vintage
Cars. Once a user selects one of those, they would only see the vehicles under each of
those product lines. These are called Cascading Parameters.
Chapter 6
[ 129 ]
Let's look at an example. In this report, we are going to modify the Employee-
Chapter6.rptdesign report we created earlier to include a drop-down parameter list
that allows a user to select a manager and list the employees that are under them,
and then select an employee and get the report for that person.
1. Open Employee-CH6.rptdesign. Save the report as Employee-Cascading-
Chapter6.
Pages:
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133