In the past we only had these containers: List, Table, Matrix, Chart in Reporting Services. In Sql Server 2008 there's a new container, a Tablix: a Table and a Matrix in one.

On the left is a table with fixed columns and dynamic rows. On the right is a matrix with dynamic columns and rows. But what do you do if you want to mix dynamic and static columns like this? With tablix, it's easy.

Example:

Tablix gives you all the features of both a table and a matrix. You can mix and match behavior of fixed or dynamic as needed. In addition, you can group data more flexibly. Groups can be nested and recursive just as in SSRS 2005, but you can also place groups adjacent to each other.

To summarize:

Matrix is dead, long live Tablix!

Comments

[duckyvideos]

Thank you.. where can I download more videos related to SSRS

[Chris Horton]

Tablix sucks. Simple things don't even work. I haven't found a way to set the row count per page, though since it pages it should be a property but isn't. There's also the issue of date controls posting back on a tab out event even if you set them to never refresh.