| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom |
|---|---|---|---|---|---|---|---|---|
Add or delete a group in a paginated report chart |
Find out how to add or delete groups, and how to create groups or nested groups in a paginated report by dragging dataset fields in Report Builder. |
maggiesMSFT |
maggies |
03/03/2017 |
reporting-services |
report-design |
conceptual |
updatefrequency5 |
[!INCLUDEssrs-appliesto] [!INCLUDE ssrs-appliesto-ssrs-rb] [!INCLUDE ssrs-appliesto-pbi-rb] [!INCLUDE ssrb-applies-to-ssdt-yes]
In paginated reports, select the chart data region to display the Chart Data pane. Create groups by dragging dataset fields to the Category Groups and Series Groups areas. To add nested groups, add multiple fields to the area.
Note
[!INCLUDEssRBRDDup]
-
On the report design surface, select the chart. The Chart Data pane appears.
-
Drag a field from the Report Data window to the Category Groups or Series Groups area. To add a parent group, position the cursor in front of an existing group. To add a child group, position the cursor after an existing group.
-
On the report design surface, select the chart. The Chart Data pane appears.
-
Right-click the group in the Category Groups area, and then select Category Group Properties.
-
Add or remove group expressions, filters, sort expressions, and group variables.
-
Select OK.
-
On the report design surface, select the chart. The Chart Data pane appears.
-
Right-click the group in the Series Groups area, and then select Series Group Properties.
-
Add or remove group expressions, filters, sort expressions, and group variables.
-
Select OK.
-
On the report design surface, select the chart. The Chart Data pane appears.
-
Right-click the group in the Category Groups or Series Groups area, and then select Delete.