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.