Friday, June 03, 2005

How to: Sql reporting services create subtotals for a matrix

Welcome to the MSDN Library: "Sorting
You can sort data within a matrix by any expression. To view instructions about sorting, click the following topic:
How to add sorting to a matrix (Report Designer)


Adding Subtotals

To add a subtotal to a matrix, add a subtotal to an individual group within the matrix. Groups do not have subtotals by default. To add a subtotal to a group, right-click the group column or row header and then click Subtotal. This will open a new header for the subtotal. Reporting Services will calculate the subtotal based on the aggregate in the data cell for the group.
For information about aggregate functions, see Aggregate Functions.
Displaying Data on Either Side of Row Headers
You are not limited to displaying row headers on the side of the matrix. You can move the row headers inward, so that columns of data appear before the row headers. To do this, modify the GroupsBeforeRowHeaders property for the matrix. You can access this property through the Properties window or the General tab of the Matrix Properties dialog box. The value for this property is an integer; a value of 2 will display two groups of matrix data before displaying the column containing the row headers."