- Dedicated trainers
- Maximum 6 per class
- Superb courseware
Phone (01457) 858877 or email
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.
- MultiValue Parameters - SSRS and Report Builder (this article)
- Creating multivalue parameters in Reporting Services
- Showing the Values Chosen for a Multivalue Parameter
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!
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.
- MultiValue Parameters - SSRS and Report Builder (this article)
- Creating multivalue parameters in Reporting Services
- Showing the Values Chosen for a Multivalue Parameter
Comments on this blog
This blog has 2 comments:
Thank you for clearly documenting the multivalue parameter usage in Reporting Services.
I was stumbling on two aspects
a) incorrectly setting the parameter filter on the dataset (not on Tablix) and,
b) using expression builder to return paramter value was returning Parameter.Value(0) by default, thus returning only one value from the selected list.
This is the best documentation I found so far on this topic. Appreciate it!