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.
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.
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
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
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
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
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
Where does status of 'Color' come from, though?
Tim
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.....
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.....
Premium Content
You need an Expert Office subscription to comment.Start Free Trial