Tablix with Grouping Under Main Row

In this article, we will be going over a setup of a common use case that comes in for Tablix, that being having the secondary row grouping be under the first rather than being in it's own column.

General idea is that you set up a column group for the main and sub row that you want in it and then have another grouping around just your main value.

Rough structure you will get:

Column row
Main Value Main Column
Sub Value Main Sub Column
Sub Value Main Sub Column

Here are the steps to do this:

Create Row Group Hierarchy

  • Right-click on the row group and select Add Row Group > Child Group
  • Then, right-click on the row group again and select Add Row > Outside Group Above.
  • Remove the leftmost extra columns.

View of final product in the designer and viewer:

Designer view of the tablix
Designer view of the Tablix

Group Editor view of the Tablix
Group Editor view of the Tablix
Outcome in the viewer showing the secondary row group under the main
Outcome inside the viewer.

Docs: https://developer.mescius.com/activereportsnet/docs/report-authors/report-controls/report-controls-page-rdl-report/tablix

Victor Stahlman