MSSQL Server Reporting Services : Mastering OLAP Reporting: Ad Hoc TopCount and BottomCount Parameters - Page 10

May 16, 2005

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.








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers