Add a details group to a paginated report (Report Builder)

Applies to: Microsoft Report Builder (SSRS) Power BI Report Builder Report Designer in SQL Server Data Tools

In a 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. You can also add back detail data that you deleted from a table or list, or to add more detail groups. For more information about groups, see Understand groups (Report Builder).

Add a details group to a tablix data region

1. On the design surface, select a tablix data region. 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. Select Add Group, and then choose Child Group. The Tablix Group dialog opens.

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

4. Select Show detail data.

5. Select 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).

Related content

• Add or delete a group in a data region in a paginated report (Report Builder)
• Groups in a Report Builder paginated report
• Tablix data region in a paginated report (Report Builder)
• Tables in paginated reports (Report Builder)
• Create a matrix in a paginated report (Report Builder)
• Create invoices and forms with lists in a paginated report (Report Builder)
• Tables, matrices, and lists in Report Builder paginated reports