What is differrence between Tabluar and Matrix reports?

Question

What is differrence between Tabluar and Matrix reports?

elchuru

Default port

Points: 1435
More actions
March 26, 2010 at 6:55 pm

#213204

Hi,
Please tell me the scenarios when we will go for Tabular and Matrix.Recently I was faced this Question.
Thanks in Advance

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

elchuru (3/26/2010)
Hi,
Please tell me the scenarios when we will go for Tabular and Matrix.Recently I was faced this Question.
Thanks in Advance

The Table control in SSRS 2005 can be used to pull data as in from any RDBMS tables you can control the look by adjust the individual column properties. I have written code that pulled almost 200 pages in a test box so I know you could use it to create a report that could be 1000 pages.

The Matrix is used if you are doing calculations of the data and I am not sure you can use it to create 1000 pages report but I could be wrong. However I know from experience that Table can be used for such report.

Kind regards,
Gift Peddie

Arunkumar S P SSCertifiable Points: 6415 More actions · Answer 2

Tabular - Number of rows vary depends on the data and Column should be fixed ( doesnot vary based on data)

Matrix - Both row and column varies depends on the data

Tablix(2008) - Combination of Table and Matrix. ( Combine fixed and dynamic column)

-----------------------------------------------------------------------------------------------------------------------------------------------------------
Please feel free to let me know if you are not clear or I’ve misunderstood anything.

Thanks,
Arunkumar S P

elchuru Default port Points: 1435 More actions · Answer 3

Hi,

Can you please tell me in which cases we will go for tabular and matrix types.

Thanks in advance

Pulivarthi Sasidhar SSCertifiable Points: 6706 More actions · Answer 4

For Cross tab reports you should go for Matrix Reports.

Ex: Ths student attendance report

take the date attribute as cross tab and Student name as Row wise.

1 2 3 4 5 6 [Date of that particular Month]

Ram 0 1 1 1 0 1

Shyam 1 1 1 1 1 1

(0 for absence and 1 for Presence on that day.)

peterzeke SSCrazy Eights Points: 9003 More actions · Answer 5

Sasidhar Pulivarthi (3/29/2010)
For Cross tab reports you should go for Matrix Reports.
Ex: Ths student attendance report
take the date attribute as cross tab and Student name as Row wise.
1 2 3 4 5 6 [Date of that particular Month]
Ram 0 1 1 1 0 1
Shyam 1 1 1 1 1 1
(0 for absence and 1 for Presence on that day.)

Going along with Sasidhar's student scenario, in contrast to the matrix example, a table example is a list such as a classroom roster of students (student name, birthdate). A matrix has an intersection of attributes (e.g., Student intersects with date of attendance); a table typically is merely a list, but certainly there can be subtotals/totals that branch off of a table.

peterlin1668 Grasshopper Points: 12 More actions · Answer 6

I think if you only want to group the results by rows then you should use TABLE. If you want to group the results by columns then you should use MATRIX.