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.