Add a New Dataset to Support the Proposed Report Parameters
will add a new dataset to support the proposed parameter picklists (the
parameter selections that the information consumers see at report run time).
Data tab, once again.
With the Dataset
selector, select <New Dataset ...>, as shown in Illustration
Illustration 28: Select <New Dataset ...>
dialog opens, defaulted to the Query tab.
following into the Name box :
In the Data
source box just below, select AdventureWorks (shared).
In the Query
string box, type (or cut and paste) the following query:
'Product Category' AS ParameterCaption,
'Category' AS ParameterValue
SELECT 'Product Subcategory' AS ParameterCaption,
'Subcategory' AS ParameterValue
SELECT 'Product' AS ParameterCaption,
'Product' AS ParameterValue
The Dataset dialog appears,
with our input, as depicted in Illustration 29.
Illustration 29: The Dataset Dialog with Our Input ...
Click OK to accept our input and to dismiss
the Dataset dialog.
We are taken to the Query
pane, where our newly crafted query appears as shown in Illustration 30.
Illustration 30: Our Query in the (Partially Depicted) Query Pane
Click the Run
(!) button to test the query.
Data is returned, and appears in
the Data Pane as depicted
in Illustration 31.
Illustration 31: Data is Returned and Appears in the Data Pane
will see how the ParameterCaption and ParameterValue fields are
employed when we set up the two report parameters in the steps that