A simple Pivot report contains a Tablix data region. This report uses the default row and column groups to display data.
This tutorial guides you through the steps to create a simple Pivot report using Tablix data region.
Note: This tutorial uses sample data set - CustomerOrders.
After you complete this tutorial, you will have a report that looks similar to the following.
Drag and drop Tablix data region onto the design area of the report. The Tablix Wizard assists in designing the Tablix. You can bind the data, and use some quick layout options to help you set styles, organize data, and add totals for the data values.
Let us now populate the Tablix data region with data. We want the titles to be displayed along the rows, different media types along the columns, and the total price corresponding to these.
Sum(Price)
Let us add a static row to display labels (static text) for the column group,
To merge the cells in the tablix corner area (top left),
To provide labels to the columns,
In Tablix data region, you need to manage how a grouped data is rendered across the rows and columns. This is done by using Group Expressions as explained below.
To display the titles once for every row group:
To display the media types once for every column group:
Note: You may need to resize and reposition the controls on the report to accommodate data, and for a cleaner look.