Create
the Parameters for TopCount and BottomCount Capabilities
We
will enable runtime selection of 1) whether the consumer wishes to retrieve top
or bottom products, and 2) the number of top or bottom products they wish to
retrieve. These capabilities will allow us an opportunity to examine to
different types of parameters / prompts.
1.
Within the Report
Parameters dialog once again, click Add.
2.
Type the
following into the Name box.
pX_OutlierType
3.
Type the
following into the Prompt box.
Top or Bottom?
4.
Ensure that
the Allow null value and Allow blank value checkboxes are
cleared.
5.
In the Available
Values section, click / select the radio button to the left of Non-queried.
6.
In the table to
the right, type in the two rows depicted in Table 3.
|
Label
|
Value
|
|
Top
|
TopCount
|
|
Bottom
|
BottomCount
|
Table 3: Expression Components Summary
7.
In the Default
Values section, click / select the radio button to the left of None.
The Report
Parameters dialog appears as depicted in Illustration 46.
Illustration 46: Report
Parameters Dialog - with Outlier Type Selector Parameter Settings
8.
Within the Report
Parameters dialog, click Add, once more.
9.
Type the
following into the Name box.
pX_TopBotNum
10.
Type the
following into the Prompt box.
Number:
11.
In the Data
type selector, select String.
12.
Ensure that
the Allow null value and Allow blank value checkboxes are
cleared.
13.
In the Available
Values section, click / select the radio button to the left of Non-queried.
14.
Leave the table
to the right empty.
15.
In the Default
Values section, click / select the radio button to the left of None.
The Report
Parameters dialog appears, as shown in Illustration 47.
Illustration 47: Parameters
Dialog - Showing Top or Bottom Number Parameter Settings
16.
Click OK to
save our additions, and to close the Report Parameters dialog.
We are
returned to the Layout tab. Now all that remains to complete
parameterization of our new report is the addition of parameter references to
the core Dataset.
» 
Comment and Contribute
