A Tablix data region displays detailed or grouped data in cells arranged into rows and columns.
Tablix has mainly four areas: the body, the row group, the column group, and the corner. The Tablix Wizard is used to populate the data in these areas of the tablix.
Drag and drop the Tablix data region onto the design surface and click Open Tablix Wizard on the right of the tablix.
Select the dataset for the Tablix.
Note: Before working on the Tablix layout design, you need to first add a dataset to your report.
Drag-drop the fields available in the dataset to:
• Rows: row group that expands downward.
• Columns: column group that expands across the page.
• Values: data where rows and columns intersect, which makes the body area. You can also modify the aggregate and format of the added value.
Set the layout of the Tablix:
• Total: to show totals or subtotals for the groups.
• Styling: to apply styles on Tablix.
◦ Set Expand and Collapse for Groups: display plus sign to expand and minus sign to collapse.
◦ Add Frozen rows and columns: set rows or columns to freeze. This is useful incase a data region contains a large amount of data (in an RDL report)and the user must scroll to see all of the data. On scrolling the column or row headers out of sight, the data becomes difficult to understand.
Lets see how groups are added in a report with Tablix data region. The Group Editor is specifically designed to manage the tablix structure.
The group expressions of the added groups can be viewed in the properties pane by selecting the row or column group from the Group Editor, or from the the tablix itself.
Let's add groups in the report with Tablix data region as shown:
Add an adjacent group
Add a Child Group
To display the aggregate price for the sale dates,
You may need to add filters on the data or apply grouping and sorting in order to get make data more organized.
Let's see how to use filters to limit the horizontal data for MediaType column group in the above tablix.
Add filter to MediaType column group so it displays only two types of media - VHS and DVD.
To display dates in the order of occurrence,
=Fields!SaleDate.Value. Set the sort order to ascending (default).
Data in tablix cells can be merged using Auto Merge Mode property which provides three options - Never, Always, and Restricted. The cells in the row groups with same data values and with Auto Merge Mode property set to:
Let us assume that we have a report with Tablix data region, similar to the following.
Use the following steps to merge the cells in the Tablix data region with similar cities.
After you complete the above steps, you will have a report that looks similar to the following.