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.

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 an SSRS report. 

Reference

• Stored Procedure in SQL Server