[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Possible to reference results in SSRS 2005 matrix?

Posted on 2012-03-14
5
Medium Priority
?
493 Views
Last Modified: 2012-06-27
I have a matrix in my SSRS 2005 and it works as expected. Now, what I want to do is reference results from that matrix. Is this possible?

Basically results in the matrix look like:

INCIDENTS    CAT1    CAT2    CAT3    CAT4 ......
----------------------------------------------------------------------
TRUE              13        238      1240     213  ......
FALSE             16        114       272      48
----------------------------------------------------------------------
Total               29        352     1512     261

I now need to do a table based on using the data from number of CAT1 True/CAT1 Total, CAT1 False/CAT1 Total, CAT1 True/CAT1 Total, CAT2 False/CAT2 Total.....

This would result with a percentage which I would need to put into a table.
0
Comment
Question by:edrz01
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 15

Accepted Solution

by:
Tim Humphries earned 1500 total points
ID: 37724144
Hi,

You can't reference individual cells / values in a matrix.

You may be best to have your second table iterate over the same dataset and just perform different calculations.

Tim
0
 

Author Comment

by:edrz01
ID: 37724594
Well bummer....

Ok, now having a brain cramp. The matrix works so easy and displays the data so well. How do I convert this to a table then?

So the table results would look like:

STATUS      CAT      %
COLOR        CAT1   55.17%
COLOR        CAT2   32.39%
COLOR        CAT3   17.99%


The percentage is calculated from the Number_Of_FALSE_per_CAT divided Total_Number_per_CAT.

For example, from the example above CAT1 would be 16/29, CAT2 would be 114/352 and so on
0
 
LVL 15

Expert Comment

by:Tim Humphries
ID: 37724724
ummm, well I'm not entirely sure I follow what you're trying to do, but if you use a table, rather than a matrix to iterate over the dataset, and on each row show the category you should be able to include your calculation in a column to the right. If you end up with two rows for each category (for true and false?) then you could just apply a filter to the table to only pull back the False rows, or if this impacts your total_number_per_cat (depending on how you're calculating that) then you could conditionally hide a detail row that is for  'True'.

Where does status of 'Color' come from, though?

Tim
0
 

Author Comment

by:edrz01
ID: 37724755
Thanks Tim, the color field would be a conditional format based upon the percentage value.

I will keep struggling through the table thing. The problem is that I have been staring at this for too long this week and probably overlooking the obvious.

I have a master table which displays all of the dat but I now need to work on getting the data out of it differently.....
0
 

Author Closing Comment

by:edrz01
ID: 37822939
ok
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Suggested Courses

656 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