Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted May 16, 2005

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

By William Pearson

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.



MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM


















Thanks for your registration, follow us on our social networks to keep up-to-date