January 31, 2012 at 5:24 am
Hi,
What is the difference in Table ,Matrix,List in SSRS
is there any difference in the behaviour
Why there was 3 instead of 1
Thanks
Parthi
January 31, 2012 at 5:53 am
Table and matrix are actually a specialisation of the tablix.
The tablix is the most general form, while the table is has only data on columns (like a table in a database), while the matrix has also data on the rows.
An example can be found here: Adding a Matrix (Reporting Services)
In the first example, the rows have the data (Accessoires - Bikes - Clothing - Components). This data comes from the Category member of the Product dimension. The intersection between the rows and the columns is a measure, LineTotal. Thus, $384,057 is the LineTotal for Accessoires in North America.
In SQL 2005, tablix did not exist, and the table and the matrix were two different objects. In 2008, you can convert a table easily to a matrix and vice versa.
Understanding the Tablix Data Region (Report Builder 3.0 and SSRS)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 31, 2012 at 5:55 am
Oh yeah, list is also a form of tablix, but it has more of a free-form layout.
More info here:
Tables, Matrices, and Lists (Report Builder 3.0 and SSRS)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 1, 2015 at 1:55 am
Table used to display detail data and have fixed Number of Columns so it allow grouping on rows.
Matrix used to display summarized data and have variable number of Columns, It allow row as well as columns level grouping.
Regards,
Alpesh Dhori
Software Professional
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply