Although
we have deleted the entry, which initially defined a Product Category
parameter, we must also delete the related Report Parameter.
24.
Select
Report -> Report Parameters ... from the main menu, as depicted in
Illustration 46.
Illustration 46: Accessing
Report Parameters ...
The Report
Parameters dialog opens.
25.
Select the
sole Report Parameter that appears within the Parameters list, ProductCategory.
26.
Click Remove
in the bottom left corner of the dialog, as shown in Illustration 47.
Illustration 47: Removing
the Report Parameter ...
The Report
Parameters dialog clears completely.
27.
Click OK to
accept our deletion, and to dismiss the Report Parameters dialog.
Having
removed the parameter and extra dataset, we are ready to add two new parameters
to customize the report to act as a target within our practice report set.
28. In the Filter pane, select Sales Territory via the Dimension column
selector button.
29. Select Sales Territory Group in
the Hierarchy column, to the immediate right of the Dimension column,
within the Filter pane.
30. Select Equal in the Operator
column.
31. Select All Sales Territories, via the checkbox within the
selector for the Filter Expression column, as depicted in Illustration
48.
Illustration 48: Select All Sales Territories
...
32. Click OK to accept the
selection.
33. In the Parameters column, to
the immediate right of the Filter Expression column, click the checkbox
to check it.
34. Click the Dimension column box
(which currently displays "<Select dimension>") in the
next row, underneath the box where we selected Sales Territory earlier.
35. Select Date via the Dimension
column selector button that appears.
36. Select Date.Fiscal Year in
the Hierarchy column, to the immediate right of the Dimension column,
within the Filter pane.
37. Select Equal in the Operator
column.
38. Leave the box in the Filter
Expression column blank.
39. Place a check in the checkbox for
the Parameters column, as we did for the box in the row above it.
The Filter
pane of the Query Designer appears, with our settings, as shown in Illustration
49.
Illustration 49: The Filter
Pane with our Settings
Next,
we will modify the new Report Parameters that were created when we
established them within the Filter pane. Settings for Parameters
are, in some cases, adequate as they are automatically created. However, the
intended use of this report, as a drillthrough target, will drive a need to
enable passthrough of parameters. This means we will need to adjust some
of the pre-established settings.
40.
Select
Report -> Report Parameters ... from the main menu, as we did
earlier.
The
Report
Parameters dialog opens, and appears, with the
pre-defined settings for the initially selected parameter, as depicted in Illustration
50.
Illustration 50: Pre-Defined
Report Parameter Settings
41.
Ensure that
the top Parameter (named SalesTerritorySalesTerritoryGroup by
default), is selected.
42.
Within the Prompt
section of the dialog, uncheck the Multi-value checkbox,
which will leave all the checkboxes in the section de-selected.
43.
Within the Available
values section, click the Non-queried radio button.
44.
In the Default
values section at the bottom of the dialog, click the Null radio
button.
The
relevant portion of the Report
Parameters dialog for the SalesTerritorySalesTerritoryGroup parameter appears, with our
adjustments, as shown in Illustration 51.
Illustration 51: Affected
Report Parameters Settings for SalesTerritorySalesTerritoryGroup
45.
Click the
second Parameter (named DateFiscalYear by default) to select it.
46.
Within the Prompt
section of the dialog, uncheck all checkboxes, as necessary.
47.
Within the Available
values section, click the Non-queried radio button.
48.
In the Default
values section at the bottom of the dialog, ensure that the Null radio
button is selected.
The
relevant portion of the Report
Parameters dialog for the DateFiscalYear parameter appears, with our
adjustments, as depicted in Illustration 52.
Illustration 52: Affected
Report Parameters Settings for DateFiscalYear
49.
Click OK
to accept our modifications and to close the Report Parameters dialog.
50.
Select File
-> Save All from the main menu, as shown in Illustration
53, to save our work to this point.
Illustration 53: Select
File -> Save All
We are
now ready to move to the third, and last, report. This report will serve as a
second target report.
» 
Comment and Contribute
