The Tablix data region organizes the data in groups by rows and columns. The row group expands vertically and the column group expands horizontally in the report.
The rows and columns inside the groups repeat once for each unique group value. The rows and columns outside the groups repeat once for the group.
You can create nested groups as well as adjacent groups in a tablix.
The easiest way to add a group in a tablix is through the Tablix Wizard. However, you can use the Cell Context Menu or the Group Editor to insert row and column groups. For more details, refer to the following sections -
The Tablix Wizard is the primary way to add row and column groups in a tablix. The wizard appears automatically when you drop the Tablix data region onto the design area or click the data region in the Report Toolbox. You can also use the Configure button to open the Tablix Wizard. For more information on Tablix Wizard, see the Tablix article.
The left pane in the wizard displays the available fields in the bound dataset.
To create a row group, drag and drop the dataset field to the Row Groups area. You can create a group hierarchy by placing multiple fields in this area organized in a specific order.
To create a column group, drag and drop the dataset field to the Column Groups area. You can create a group hierarchy by placing multiple fields in this area organized in a specific order.
The corresponding buttons next to the fields placed in the Row Groups and Column Groups areas allow you to specify the sorting order and change the data format for the field. Use the Swap button in the Row Groups area to swap the rows and column groups.
The cell context menu in a tablix provides options to create both nested and adjacent groups. You can access these options by right-clicking the cell in the tablix data region.
Row Group - To insert a row group in a tablix, choose from the following options.
Column Group -To insert a column group in a tablix, choose from the following options.
The Group Editor in the Report Toolbox shows the row and column hierarchies for the currently selected Tablix data region. It also provides you options to add nested and adjacent groups to the chosen group in the editor.
To add a row group to the currently selected row group, click the Vertical Ellipsis icon and choose from the following options.