?
Solved

ssrs ... creating report using matrix

Posted on 2014-09-10
2
Medium Priority
?
236 Views
Last Modified: 2014-09-24
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
Comment
Question by:motioneye
2 Comments
 
LVL 49

Assisted Solution

by:PortletPaul
PortletPaul earned 400 total points
ID: 40316263
Have you ever used a pivot table in Excel? It is the same concept.
0
 
LVL 37

Accepted Solution

by:
ValentinoV earned 1600 total points
ID: 40318674
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

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Server 2003 introduced persistent Volume Shadow Copies and made 2003 a must-do upgrade.  Since then, it's been a must-implement feature for all servers doing any kind of file sharing.
Measuring Server's processing rate with a simple powershell command. The differences in processing rate also was recorded in different use-cases, when a server in free and busy states.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question