SSRS Report Using Stored Procedure

Introduction

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

Output

The following screenshot shows the output of the report.

 
Figure 10 Output

Summary

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