[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 494
  • Last Modified:

Possible to reference results in SSRS 2005 matrix?

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
edrz01
Asked:
edrz01
  • 3
  • 2
1 Solution
 
Tim HumphriesCommented:
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
 
edrz01Author Commented:
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
 
Tim HumphriesCommented:
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
 
edrz01Author Commented:
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
 
edrz01Author Commented:
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.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now