Procedure: Add Support for Multiple Value Selection in a Report
procedure for creating a Report Parameter in Reporting Services 2005
is similar to doing so in Reporting Services 2000. Many of the following
steps will be familiar to most of us. Our specific focus in this section will
be the addition of support for multiple value selection in the parameter
picklist, which involves additional settings in the Report Parameter
dialog, as well as a change in operators, within our sample report, at the
Create a New Report
Parameter with Multiple Value Selection Support
--> Report Parameters from the main menu atop the Report
Designer, as we did earlier.
Report Parameters dialog appears.
following into the Name box atop the dialog:
following into the Prompt box :
insert a check mark) the checkbox to the immediate left of the Multi-value,
one of five checkboxes appearing under the Prompt box.
checkbox, a new option with Reporting Services 2005, enables the support
of multiple selections in the picklist for our new Report Parameter.
the Allow null value and Allow blank value check boxes are
Click the From
query radio button in the Available values section of the dialog.
here that we align the ProductList Dataset, designed to populate the
picklist that appears to the information consumers at runtime. Clicking the From
query radio button enables the settings to its right, where we select the
Dataset: the report Dataset from
which the values that appear in the drop-down selector are taken;
Value field: the Dataset field from
which the value(s) used by the report (within a filter or other component) is
Label field: the Dataset field from
which the values that appear to the consumer in the picklist at runtime are
in the Dataset selector.
in the Value field selector.
in the Label field selector.
Click the From
query radio button in the Default values section of the dialog.
again, we note that selectors are enabled, this time a selector for Dataset
and a selector for Value field, which serve similar functions with
regard to the default parameter values.
in the Dataset selector, as before.
the Value field selector, again as before.
Parameters dialog appears, with our input, as depicted in Illustration 20.
Illustration 20: The
Report Parameters Dialog
to accept our input and to close the Report Parameters dialog.
Parameters dialog closes, and we are returned to the Layout view of
the report, once again.