Solved

ssrs ... creating report using matrix

Posted on 2014-09-10
2
216 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 48

Assisted Solution

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

Accepted Solution

by:
ValentinoV earned 400 total points
Comment Utility
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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
OfficeMate Freezes on login or does not load after login credentials are input.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

743 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now