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

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Nov 14, 2005

MSSQL Server Reporting Services: Mastering OLAP Reporting: Multiple Value Selection in a Parameter Picklist - Page 6

By William Pearson

Procedure: Add Support for Multiple Value Selection in a Report Parameter

The procedure for creating a Report Parameter in Reporting Services 2005 is similar to doing so in Reporting Services 2000. Many of the following steps will be familiar to most of us. Our specific focus in this section will be the addition of support for multiple value selection in the parameter picklist, which involves additional settings in the Report Parameter dialog, as well as a change in operators, within our sample report, at the matrix filter.

Create a New Report Parameter with Multiple Value Selection Support

1.  Select Report --> Report Parameters from the main menu atop the Report Designer, as we did earlier.

The empty Report Parameters dialog appears.

2.  Click Add.

3.  Type the following into the Name box atop the dialog:


4.  Type the following into the Prompt box :

Product Family(ies):

5.  Click (to insert a check mark) the checkbox to the immediate left of the Multi-value, one of five checkboxes appearing under the Prompt box.

This checkbox, a new option with Reporting Services 2005, enables the support of multiple selections in the picklist for our new Report Parameter.

6.  Ensure that the Allow null value and Allow blank value check boxes are cleared.

7.  Click the From query radio button in the Available values section of the dialog.

It is here that we align the ProductList Dataset, designed to populate the picklist that appears to the information consumers at runtime. Clicking the From query radio button enables the settings to its right, where we select the following:

  • Dataset: the report Dataset from which the values that appear in the drop-down selector are taken;
  • Value field: the Dataset field from which the value(s) used by the report (within a filter or other component) is taken;
  • Label field: the Dataset field from which the values that appear to the consumer in the picklist at runtime are taken.

8.  Select ProductList in the Dataset selector.

9.  Select ID_Product___Product_Family___MEMBER_CAPTION_ in the Value field selector.

10.  Select ID_Product___Product_Family___MEMBER_CAPTION_ in the Label field selector.

11.  Click the From query radio button in the Default values section of the dialog.

Once again, we note that selectors are enabled, this time a selector for Dataset and a selector for Value field, which serve similar functions with regard to the default parameter values.

12.  Select ProductList in the Dataset selector, as before.

13.  Select ID_Product___Product_Family___MEMBER_CAPTION_in the Value field selector, again as before.

The Report Parameters dialog appears, with our input, as depicted in Illustration 20.

Illustration 20: The Report Parameters Dialog

14.  Click OK to accept our input and to close the Report Parameters dialog.

The Report Parameters dialog closes, and we are returned to the Layout view of the report, once again.

MS SQL Archives

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