February 21, 2012 at 4:03 pm
I need to create a report with a collection of gauges. The data coming into the report is structured like:
Client Specialty TrendsPercent
ABC Hematology 33.2
ABC Urgent Care 30
DEF Psychiatry 80
DEF Pulmonary 59
DEF Neurology 12
The number of rows for each client, as well as the specialties listed, is variable. What I've been trying to do is create a 5x5 grid of gauges. Each row in the original data will be a gauge. So:
Row1Gauge | Row2Gauge | Row3Gauge | Row4Gauge | Row5Gauge
-----------------------------------------------------------------
Row6Gauge | Row7Gauge | Row8Gauge | Row9Gauge | Row10Gauge
etc.
The problem I've been running into is how do I reference one specific row's data based solely on the row number? There are too many gauges to just have one column in a tablix object, I need to have the gauges 5 wide at least. I've tried filtering a tablix based on the RowNumber but SSRS doesn't allow that. Any ideas on how I could go about this?
February 22, 2012 at 10:17 am
I was able to figure out a work around for this. While you can't filter a tablix based on row number you CAN set visibility based on it. So, I have 5 tablixes side by side and I'm setting the visibility on the first one to show for rows 1, 6, 11, 16, 21. The tablix next to it is only showing rows 2, 7, 12, 17, 22, etc. I don't know how this is going to affect the performance when the report is used on the sharepoint site, but I know of no other way of going about this.
February 22, 2012 at 11:51 am
The "Percent Rejected Dashboard Report" from Brian Larson's "Delivering Business Intelligence" book might do the trick for you. The report will show one Client per row with a column for each specialty.
Based on your sample data set it would look like this:
ABCHematologyUrgent Care
DEFPsychiatryPulmonary Neurology
Steps:
1. Drop a table in your report
2. Add Your "Client" field in the lower left cell
3. In Row group properties, add a group expression and group on the Client field
4. Delete the header row and the two right columns
4. Drop a matrix into the table cell
5. Add your "Client" field in the Rows field
6. Add your "Specialty" field in the Columns field
7. Add your gauge in the data row
8. Add a label to your gauge, use text expression to add your "Specialty" field as the expression
9. Delete the top row in the matrix, selecting the "Delete rows only" option and preview
February 22, 2012 at 1:48 pm
Thank you for the response! Unfortunately there can be 15+ specialties per client so showing the whole string of gauges as one horizontal row wouldn't look good either. My workaround solution involving 5 tablixes made it so there were a max of 5 gauges per row.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply