asked on

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.

ASKER CERTIFIED SOLUTION

Tim Humphries

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

edrz01

ASKER

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

Tim Humphries

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

edrz01

ASKER

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.....

edrz01

ASKER