Solved

Possible to reference results in SSRS 2005 matrix?

Posted on 2012-03-14
5
485 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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

830 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