SSRS Report Using Stored Procedure With Multiple Parameters

Introduction

This article shows how to use a Stored Procedure with multiple parameters for SSRS reports.

Create a Report Server project as in Figure 1.


Figure 1: Report Server Project

Add a new Report item as in Figures 2 and 3.

 

Figure 2: Add New Item

 

Figure 3: Add Report

Add a Data Source as in Figures 4 and 5.

 

Figure 4: Configure DataSource

 

Figure 5: Choose appropriate Stored Procedure

Use the table as in Figures 6 and 7.

 

Figure 6: Insert Table

 

Figure 7: Choose DataSource and create a query

Set up the table with the dataset's fields as in Figure 8.

 

Figure 8 Design view of created table

The output of the report is as in the following:

 

Figure 9: Output

Summary

In this article we saw how to use a Stored Procedure with multiple parameters for SSRS reports.