List in SSRS Report

Introduction

This article shows how to use a List in SSRS report.

Create a Report Server project as in Figure 1.

Figure 1: Report Server Project

Add a new Report item as in Figure 2.

 

Figure 2: Add Report

Add a Data Source as in Figurew 4 and 4.

 

Figure 3: Configure DataSource

 

Figure 4: Choose appropriate Stored Procedure

Use a List as in Figures 5 and 6.

 

Figure 5: Insert List

 

Figure 6: Choose DataSource and create a query

The output of the report is as in Figures 7 and 8.

 

Figure 7: Design view of list

 

Figure 8: Output

Summary

In this article we saw how to use a List in SSRS report.