Introduction
This article shows how to use a Stored Procedure with multiple parameters for SSRS reports.
Create a Report Server project as in Figure 1.
Figure 1: Report Server Project
Add a new Report item as in Figures 2 and 3.
Figure 2: Add New Item
Figure 3: Add Report
Add a Data Source as in Figures 4 and 5.
Figure 4: Configure DataSource
Figure 5: Choose appropriate Stored Procedure
Use the table as in Figures 6 and 7.
Figure 6: Insert Table
Figure 7: Choose DataSource and create a query
Set up the table with the dataset's fields as in Figure 8.
Figure 8 Design view of created table
The output of the report is as in the following:
Figure 9: Output
Summary
In this article we saw how to use a Stored Procedure with multiple parameters for SSRS reports.