How to create a stepped report in Syncfusion WPF ReportDesigner

Syncfusion ReportDesigner allows you to create and visualize the data by grouping the data region items. Grouping pane explorer in the design panel displays the row and column groups for the currently selected Tablix data region item. It contains the following two modes.

• Default Mode: Displays a hierarchical view of the dynamic members for row and column groups.
• Advanced Mode: Displays both dynamic and static members for row and column groups. 

The following steps guide you to create a report with the Tablix report item by grouping the data.

1. Create a new report, add embedded datasource and dataset.
2. Draw a table report item and add the fields to table from the report data explorer by expanding Dataset (Sales).
3. In the report design view, click the table to select it. Grouping pane displays the row and column groups of selected items.
4. If you are unable to view the grouping pane after selecting, click View tab in ribbon toolbar and enable the Grouping.
5. To add parent group, right-click the details row groups, click the Add Group, and then select Parent Group from the Row groups.

6. You can add the groups in Tablix report item from ‘Grouping pane’ or through ‘Context Menu’ by selecting the Tablix cell.
7. Then, the Tablix group wizard will open to choose the field from the dropdown list or type the expression in ‘Expression Dialog’ to add a parent or child group.

8. Here, Tablix group based on the unique Product Category value (ProdCat is added as parent group for detail rows).

9. By clicking the OK button, product category [ProdCat] field is added as parent group for sub category [SubCat] field values.
10. Preview the report.

11. To delete a group, in the grouping pane, select and right-click the group that to be removed, and then click Delete Group option.

12. In the Delete Group dialog box, select any one of the following options:

1. Delete group and related rows and columns: Choose this option to delete the group definition and all related rows that displays the group data. For the details group, if the same row belongs to both detail and group data, only the detail data rows are deleted.
2. Delete group only: Choose this option to keep the structure of the table data item the same and delete only the group definition.

13. Click OK.

Please download the tablix grouping report here