Solved

Possible to reference results in SSRS 2005 matrix?

Posted on 2012-03-14
5
479 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
  • 3
  • 2
5 Comments
 
LVL 15

Accepted Solution

by:
Tim Humphries earned 500 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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
Time Corrections for Reports Working with a report, we made some interesting discoveries about the time corrections/updates We are using the following Parameters: Starting Entered Date (Date) formatted as Data type: "Date/Time" Ending Entered …
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

758 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

21 Experts available now in Live!

Get 1:1 Help Now