Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
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.
Solved
Possible to reference results in SSRS 2005 matrix?
Posted on 2012-03-14
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.
-
3
2
5 Comments
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
Active 4 days ago
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
Active 4 days ago
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.....
Featured Post
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
How to use Variables and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS.
Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
Hi All,
I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
Free Data Recovery software is an advanced solution from Kernel Tools to recover data and files such as documents, emails, database, media and pictures, etc. It supports recovery from physical & logical drive after a hard disk crash, accidental/inte…
Watch the video to know the process of migration of Exchange or Office 365 mailboxes in absence of MS Outlook. It is an eminent tool which can easily migrate Public, Archive user mailboxes from one another Exchange server and Office 365. Kernel Migr…
Suggested Courses
Course of the Month9 days, 5 hours left to enroll
595 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.