Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
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.
COURSE of the MONTH
9 days, 4 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
Active 5 days ago
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
Active 5 days ago
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.....
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Written by Valentino Vranken.
Introduction:
The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source. The data…
Written by Valentino Vranken.
Introduction:
In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses
Course of the Month9 days, 4 hours left to enroll
764 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.