Add a Details Group (Report Builder and SSRS)

 

Applies To: SQL Server 2016

In a Reporting Services paginated report, the detail data from a report dataset is specified as a group with no group expression. Add a detail group to an existing tablix data region when you want to display the detail data for a matrix, add back detail data that you have deleted from a table or list, or to add additional detail groups. For more information about groups, see Understanding Groups (Report Builder and SSRS).

System_CAPS_ICON_note.jpg Note


You can create and modify paginated report definition (.rdl) files in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items.

  1. On the design surface, click anywhere in a tablix data region to select it. The Grouping pane displays the row and column groups for the selected data region.

  2. In the Grouping pane, right-click a group that is an innermost child group. Click Add Group, and then click Child Group. The Tablix Group dialog box opens.

  3. In Group expression, leave the expression blank. A details group has no expression.

  4. Select Show detail data.

  5. Click OK.

    A new details group is added as a child group in the Grouping pane, and the row handle for the group you selected in step 1 displays the details group icon. For more information about handles, see Tablix Data Region Cells, Rows, and Columns (Report Builder) and SSRS.

Add or Delete a Group in a Data Region (Report Builder and SSRS)
Understanding Groups (Report Builder and SSRS)
Tablix Data Region (Report Builder and SSRS)
Tables (Report Builder and SSRS)Matrices (Report Builder and SSRS)
Lists (Report Builder and SSRS)
Tables, Matrices, and Lists (Report Builder and SSRS)

Community Additions

ADD
Show: