MSSQL Server Reporting Services : Mastering OLAP Reporting: Ad Hoc TopCount and BottomCount Parameters - Page 10May 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.
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.
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.
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
Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers
