Monday, February 24, 2014

Matrix Report in SSRS

Table reports can be fine for logging detailed transactions and lists, but business reporting is
Often about summarizing information for analysis and providing context to all the numbers and
Listed items. This is often best done by rolling up the details along groups and hierarchies, then
Viewing the aggregate totals, rather than the details.

A matrix, cross-tab, or pivot report aggregates data along a grid’s x-axis and y-axis to form a
summarized table, The most unique characteristic of a matrix is that columns are not static but
are based on grouped values. Both rows and column groups may be multilevel hierarchies, and
there may be an infinite number of grouped members on rows and columns.

A matrix is most useful for viewing aggregated values along two different dimensional
hierarchies, such as time and geography. For example, a product sales summary report might
show aggregated sales with years and months on the columns axis, and the customers’
countries and regions along the rows axis. At the intersection of each member along each axis,
a cell displays the summarized product sales for that time and geography. For example, a
single cell might represent the total sales for April 2008 in Berlin, Germany.

After 2008 both of these report styles use the tablix report item under the covers, the option to
design a table, matrix, or list report simply applies a set of template properties to a tablix
object. Regardless of what the designer does behind the scenes, you still select one of these
specific report items to place in the report body. The only significant difference between a table
and a matrix is that the columns of a matrix are dynamically generated from grouped values.

No comments:

Post a Comment