Introduction
This article shows how to use a Stored Procedure with a parameter 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, 5, 6 and 7.
Figure 4 Add Datasource.
Figure 5 Configure Datasource
Figure 6 Add dataset
Figure 7 Choose datasource and create a query
Use the table as in Figures 8 and 9.
Figure 8 Insert table.
Figure 9 Configure datasource for table
Set up the table with dataset fields as in Figure 10.
Figure 10 Design view of created table
The output of the report is as in the following:
Figure 11 Output before data
Figure 12 Output after data
Summary
In this article we saw how to use a Stored Procedure with a parameter for SSRS reports.