Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT
Course Of The Month
1 day, 15 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
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.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
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 today
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 today
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
![[Webinar] How Hackers Steal Your Credentials](https://filedb.experts-exchange.com/files/public/2017/5/20/3315d9d8-8110-4d52-be94-a5aacdd83e4b.png)
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Introduction
As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset. This makes it troublesome when you need to display data from more than one dataset in the same data region. SQL Serve…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash"
After Shake : http://www.videocopilot.net/presets/after_shake/
All lightning effects with instructions : http://www.mediaf…
Suggested Courses
Course of the Month1 day, 15 hours left to enroll
717 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.