Matrix boxes

When we already have the table data region that allows us to group the dataset on row level, what would the matrix data region give us as an added value? The answer is: column groupings.

Basically, a matrix is like a crosstab or pivot table in Excel. A matrix can have dynamic columns and rows and static columns and rows. A matrix data region in Reporting Services is very much like a matrix control on a form in the Dynamics NAV Classic Client. It's not completely the same. This is the definition of the Matrix control in the Classic Client:

A matrix box is a composite control that can show information from several tables at the same time. The first two tables are the vertical and the horizontal table of the matrix box control. In the matrix part of the control, each cell can be used to display information that is calculated on the basis of fields in these two tables, or information that is retrieved from other tables (with values from the first two tables being used to select records...