• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

ssrs ... creating report using matrix

I'm trying to understands, how these column groups, row groups and values are related to each other when we pick and presenting data via this page.

ssrs
0
motioneye
Asked:
motioneye
2 Solutions
 
PortletPaulfreelancerCommented:
Have you ever used a pivot table in Excel? It is the same concept.
0
 
ValentinoVBI ConsultantCommented:
The dataset in that screenshot doesn't seem to contain useful data for a matrix.  Building further on what you've done there, if you'd put PostalCode in the Values box each row would show a phone number and some sums of postal codes (unless phone number is unique, which is probably the case here).  As you can see, doesn't make much sense does it?

The following MSDN page shows a more suitable example in which sales numbers get summed by region in the columns and product category in the rows: Matrices (Report Builder and SSRS)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now