SSRS Report Using Stored Procedure

Introduction

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

Create a report server project.

SSRS Report Using Stored Procedure

Figure 1 Create Report Server Project

Add new report item

SSRS Report Using Stored Procedure

Figure 2 Add new Report Item 

SSRS Report Using Stored Procedure

Figure 3 Report

Add data source

SSRS Report Using Stored Procedure

Figure 4 Add New Data Source 

SSRS Report Using Stored Procedure

Figure 5 Shared Data Source properties 

SSRS Report Using Stored Procedure 

Figure 6 Shared DataSet Properties

Use table

SSRS Report Using Stored Procedure

Figure 7 Use Table

SSRS Report Using Stored Procedure 

Figure 8 DataSet Properties

Setup table with dataset fields

SSRS Report Using Stored Procedure

Figure 9 Setup Table with DataSet Fields

Output

The following screenshot shows the output of the report.

SSRS Report Using Stored Procedure 

Figure 10 Output

 

Summary

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

Reference


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