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.