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.

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:

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!

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!