Friday, March 6, 2009

Tablix – The Matrix Revolution


Tablix – The Matrix Revolution

Tablix is the new underlying flexible data region and grouping structure introduced in Reporting Services 2008.  Among other features, it enables asymmetric layouts, as demonstrated in the thumbnail screenshot below. 

Tablix Example - click to see larger version

If you use a list, table, matrix, chart, gauge, or custom report item in RS 2008, you are really using a tablix beneath the covers.  Ever since the first public revealing of tablix at TechEd conference in June 2007, and making it available shortly after in CTP 4 of SQL Server 2008, a lot has been said about tablix (e.g. see Teo Lachev’s: Tablix – The Crown Jewel posting).

As the developer who implemented tablix in the new on-demand report processing engine of Reporting Services 2008, I wanted to share my perspective on how report authors can get even more out of tablix.  This is the first posting in a series of postings, focused on exploring several of the tablix capabilities.  In one of the upcoming postings I will explain key building blocks of the report shown above.

So what’s the meaning of the word “tablix”?

Tablix = Table + Matrix

A tablix combines all the features of a table and a matrix.  In addition, it adds new capabilities such as:

  • an unlimited number of (un)correlated side-by-side groups on rows and columns

  • more layout flexibility, such as stepped column layouts in addition to nesting

  • subtotals have explicit cell definitions - no need to use InScope to determine the current scope dynamically

  • the matrix corner is now a grid corresponding to the row/column group structure

With that, you no longer have to determine upfront if you need a table or matrix (sometimes also called crosstab) layout.  You can change the tablix layout on-the-fly as you refine the report design or adjust for new requirements later.

Posted: Thursday, March 05, 2009 11:10 PM by Robert M. Bruckner

Robert Bruckner's Advanced Reporting Services Blog : Tablix – The Matrix Revolution

1 comment:

daspeac said...

it seems you have never heard about the ms sql database recovery tool

Blog Archive