In a Page report and RDLX report, you can set grouping to organize data in your reports. The most common grouping scenario is to create groups by fields or expressions in a data region.
Depending on the data region you select, you can group data in one of the following ways:

• In a Table or BandedList, you can add group header and footer rows. You can also set detail grouping in the Table data region.
• In a List, you can set detail grouping.
• In a Tablix, you can add columns and rows either dynamically or manually to group data.
• In a Classic Chart , you can group data by categories or series.

Group in a FixedPage

In a Page report, you can group your data on the fixed page. A group set on the fixed page, applies to the entire report including the controls within the report. Therefore, once you set grouping here, you may decide not to group individual data regions. See Page Report topic for more information on properties available for grouping data.

Use the following steps to understand how to apply grouping on a fixed page. These steps assume that you have already added a Page report template, connected it to a data source and created a dataset.

1. Right-click the gray area outside the design surface and select Fixed Layout Settings or with the fixed page selected, under the Properties Panel, click the Property dialog link to open the FixedPage dialog.
2. On the Grouping page, in the General tab, under Group on enter the field name or expression on which you want to group the data. For example, =Fields!YearReleased.Value.
   Note: A default group name like FixedPage1_Group appears under Name, once you set the group. To modify the group name, add a field name or expression under Group on to enable the Name option and enter a new name. 
3. Under the Document map label field, you can optionally set a label to add the item to the document map.
4. Click OK to close the dialog.
5. Drag and drop a data region, for example, a Table data region, onto the design surface and set data inside its cells.
6. Go to the Preview Tab to view the result. You'll notice that the data appears in groups sorted according the YearReleased field on each report page.
   

Detail Grouping

Detail grouping is available in the List and Table data regions. It is useful when you do not want to repeat values within the details. When you set detail grouping, the value repeats for each distinct result of the grouping expression instead of each row of data.

For example, in Table topic, if you do not set detail grouping, you see each year as many times as there are movies from that year.

If you set detail grouping to =Fields!YearReleased.Value, each year appears only once.

Recursive Hierarchies

If you want to display parent-child relationships in your data, you can create a recursive hierarchy. To do this, you need a unique ID field for the child group and an ID field for the parent group.

For example, if you have pulled data from the Reels database using the following SQL query:

You can set Detail Grouping in a Table data region using the =Fields.Item("EmployeePosition.PositionID").Value field, and the =Fields!ManagerPosition.Value field as the parent group to display parent-child relationships in your data. To view the hierarchy level, add another column in the table and add expression =Level().

Level Function

To better visualize data in a recursive hierarchy, you can use the Level function, which indents text and further clarifies the relationships between parent and child data. To do this, you set an expression in the Padding - Left property of the text box you want to indent.

For example, in a Table data region, for the recursive hierarchy example above, you can set the following expression in the Padding - Left property of the text box that contains the 'Title' to indent values according to levels: