Multivalue parameters in Reporting Services
Part one of a three-part series of blogs

This blog shows how to create multivalue parameters based on dropdowns, whether in SQL Server Reporting Services or Report Builder 3.0.

  1. MultiValue Parameters - SSRS and Report Builder (this blog)
  2. Creating multivalue parameters in Reporting Services
  3. Showing the Values Chosen for a Multivalue Parameter

Posted by Andy Brown on 07 November 2011

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

MultiValue Parameters - SSRS and Report Builder

This blog shows how you can create multivalue parameters in both SQL Server Reporting Services 2008 R2 (the techniques are the same as for previous versions) and in Report Builder 3.0.

Example of multivalue parameter - studio dropdown

A typical multivalue parameter - we're choosing the list of studios for which to display films

 

When you choose a multivalue parameter combination, your report should show you (in this case) all films made by the chosen studios:

Report showing selected films

The films for the studios selected

This blog shows you how to create a multivalue parameter like this, and also how to get the clever titles working!

Multivalue choices shown at top of report

You can use the JOIN function to show the choices made - see later in this blog for more details.

 

The first thing to do is to create the multivalue parameter and incorporate it into your report!

 

This blog has 0 threads Add post