SSRS Report Using Stored Procedure


This article shows you how to use a Stored Procedure for a SSRS report.

Create report server project

Figure 1 Create Report Server Project

Add new report item

Figure 2 Add new Report Item 

Figure 3 Report

Add data source

Figure 4 Add New Data Source 

Figure 5 Shared Data Source properties 
Figure 6 Shared DataSet Properties

Use table

Figure 7 Use Table
Figure 8 DataSet Properties

Setup table with dataset fields

Figure 9
 Setup Table with DataSet Fields


The following screenshot shows the output of the report.

Figure 10 Output


In this article we saw how to use a Stored Procedure for a SSRS report. 

Similar Articles
MVC Corporation
MVC Corporation is consulting and IT services based company.