SSRS Report Using Stored Procedure With Parameter

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.