11. Under Parameters, select dsprmEmployeeID, and click on the Edit button.
12. Set the Linked to Report Parameter to rprmEmployee.
13. Save the report, and Preview.
Now, when you run the report, you will have two new parameters. When you select
the Manager drop-down, the second list will get smaller. So if you select All, then
all of the Employees will appear in the second drop-down list. Change the Manager
drop-down to anyone else, and that list of Employees changes.
Report Parameters
[ 134 ]
Parameter Grouping and Reports with
Multiple Parameters
While we won't cover this here in detail, I would like to discuss it briefly. With
reports you can create multiple Report Parameters, and bind them to a single Data
Set or to multiple Data Sets. Just because a parameter has already been bound once,
it does not mean it cannot be bound again. When you create a Report Parameter,
that parameter becomes a global variable for your report that can be used anywhere
else in the report. You can also use multiple parameters in a single Data Set??”both
as prepared parameters for queries and as filters. For example, let's say you have a
query that pulls all orders for a particular market and a date range. In this query, you
would have three parameters, one for the market, and two for the start date and end
date.
Pages:
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135