In a previous article I announced that I would write a sequel covering how to pass multiple-value parameters from a SQL Server Reporting Services report to a stored procedure. So that’s what I will be writing about in this article.
As usual, I will be using the AdventureWorks2008 sample database (running on SQL Server 2008 SP1), downloadable from CodePlex.
The examples in this article, Part 2, are building further on the result achieved when following the steps described in Part 1, so please refer to the previous article if needed.
Passing Multi-Value Parameter To Stored Procedure
As we’ve already seen in Part 1, parameters can be passed from a Reporting Services report to a stored procedure. The parameter that was used was just a simple, single-valued parameter. However, a report parameter can be defined as being multi-value. Let’s set one up!
Our report currently shows a list of employees who were hired after the selected hire date. One of the columns being shown is the department in which they’re active. We will modify the report so that it’s possible to filter the data on department – only the selected departments are to be retrieved from the database.
