List Data Region in SSRS

A list data region repeats with each group or row in the report dataset. A list can be used for free-form reports or in conjunction with other data regions. You can define lists that contain any number of report items. A list can be nested within another list to provide multiple groups of data.


New List report item on the design surface

When you select a list on the design surface, row and column handles appear, as shown in the following figure.


New List added from Toolbox, selected

The list you start with is a template based on the Tablix data region. After you add a list, you can continue to enhance the design by changing the the content or appearance of the list by specifying filter, sort, or group expressions, or changing the way the list displays across report pages. For more information, see Controlling the Tablix Data Region Display on a Report Page (Reporting Services). Although the list starts with a single column and row, you can further continue to develop your list design by adding nested or adjacent row groups or column groups, or adding additional detail rows. For more information, see Exploring the Flexibility of a Tablix Data Region.


If you have a report model data source, you can also create simple list reports using Report Builder. For more information, see How to: Start Report Builder.


The following figure shows a list that displays information about an order, including these fields: Date, Order, Qty, Product, LineTotal, and an image.


List in design view, 4 fields and an image

In Preview, the list repeats to display the field data in the free-form format, as shown in the following figure:


Preview for List with 4 fields and one image


Displaying Data with One Level of Grouping Because a list automatically provides a container, you can use a list to display grouped data with multiple views. To change the default list to specify a group, edit the Details group, specify a new name, and specify a group expression.

For example, you can embed a table and a chart that show different views of the same dataset. You can add a group to the list so that the nested report items will repeat once for every group value. The following figure shows a list grouped by product category. Notice that there is no detail row. Two tables are nested side by side in the list. The first table displays the subcategories with total sales. The second table displays the category grouped by geographical area, with a chart that shows the distribution of subcategories.


A list with 2 tables, one with nested chart



In Preview, the table displays total sales for all subcategories of bicycles, and the table beside it displays the breakdown of sales per geographical area. By using an expression to specify the background color for the table and a custom palette for the chart, the first table also provides the legend for the chart colors.


Preview, 2 tables, one with nested chart