How to use SSRS parameters with stored procedures
You can pass values from a single-value report parameter or a multi-value report parameter to a stored procedure, to populate an SSRS report. With a multi-value report parameter, you can select more than one value to filter the report data. In general, SSRS report parameters let you control report data, connect related reports together, and vary report presentation.
09 Apr 2014
Demo on how to pass values from a single-value report parameter to a stored procedure
This is an easy-to-follow walkthrough on how to configure a report to connect to a stored procedure that accepts two input parameters. As shown in the article, report parameters are automatically created for the stored procedure parameters. The author has provided a lot screenshots to help you.
Demo on how to pass values from a multi-value report parameter to a stored procedure
The author uses an example that has two stored procedures, the first one returns a list of sales territories and the second one returns a list of sales reps for the sales territories. The SSRS report contains two multi-value parameters that return selected values to the stored procs. The article shows you how to create the procedures, how to use a Split Function to break up the delimited list of territory ID values, and how to use the JOIN expression to return the report parameter values to the store procedures. There are SQL examples, and screen shots for the report parameter and dataset UI.
Add a multi-value parameter to a Report
If you're interested in just learning how to create a multi-value parameter and use it to filter table data, this article provides step-by-step instructions.