Gauge control in SSRS 2008 R2
I have a table with two groups, product category and then sub-category and each have a group total which is Sum(SalesAmount). the gauge control is present in the details row of the table. to the gauge control i have added 3 ranges, and gave each of them a color. The first range has Green color when the range has a minimum value of 1 and maximum of SUM(SalesAmount)/3. The second range has a Yellow color when the range is between SUM(SalesAmount)/3 and SUM(SalesAmount)*2/3. The final range has a Red color when the range is between SUM(SalesAmount)*2/3 and SUM(SalesAmount). The problem i am facing with the gauge control is that the colors of the range are not behaving as expected. While previewing the report, where ever the pointer stops showing some value the three colors are spanning from 1 to where the pointer position is. And that is not what i am trying to accomplish. what i want is over the scale for the first 33% i.e. from 1 to sum(salesamount)/3 the scale should be green and yellow from 33 to 66 and red after wards. And based on the value of the sales amount the point should be with the green, yellow or red regions. Any thoughts??
November 9th, 2012 4:42am

Hi Ramzanna, From your description, you want to divide the linear into three parts and each part has different color, right? As per my understanding, this cannot be achieved in Reporting Services currently. A workaround for this is use the linear scale rang in the middle of the linear and set the back color of linear gauge to Gradient. The steps below are for your reference. 1. Right-click gauge and select Gauge Properties. 2. Select Back Fill tab in the left pane, and select Gradient in the Fill style radio button. 3. Right-click range and select Range Properties and then set the properties like below. The screenshots below are for your reference. If you have any questions, please feel free to ask. Regards, Charlie LiaoCharlie Liao TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
November 12th, 2012 9:53pm

Hi Charlie First, thanks for answering. the gauge control I am using is a radial one. I thought that should not make a difference, but infact there is a difference. the "back fill" of radial gauge's properties does not have fill style as you indicated above. it just asks to select a color. But thank you -Ramesh
November 15th, 2012 12:21am

Free Windows Admin Tool Kit Click here and download it now
November 15th, 2012 12:33am

Hi Ramzanna, I am sorry for ignoring that the gauge control you are using is a radial. I have test it, the workaround that I provide in the above post just work for Linear. So I am afriad that your requirement cannot be achieved in Reporting Services currently, if you have any concerns about this feature, you can submit a feedback at http://connect.microsoft.com/SQLServer/Feedback and hope it is resolved in the next release of service pack or product. Thank you for your understanding. Regards, Charlie LiaoCharlie Liao TechNet Community Support
November 15th, 2012 12:57am

Sorry, but maybe I didnt get the requirement correctly. Why cant you just create 3 ranges in your radial gauge and set the start and end for each range appropriately? And you can set the color for each range individually as first range should be green, second range should be yellow and third range should be red Cheers, Jason | www.SqlJason.com P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
Free Windows Admin Tool Kit Click here and download it now
November 15th, 2012 11:50am

Not certain I have the correct understanding but it seems that the problem you are experiencing is a scope problem. The Sum(SalesAmount) you want is the sum of the SalesAmount field for the group. Is that correct? If so, since the gage is in the detail, it is scoped to the detail which means that Sum(SalesAmount) is essentially the same as SalesAmount. Try setting your ranges by specifying the group as the scope for the Sum: =SUM(SalesAmount,"SubCategory")/3 (or =SUM(SalesAmount,"Category")/3 if that is the desired scope)Please Mark posts as answers or helpful so that others can more easily find the answers they seek.
November 15th, 2012 1:49pm

Sorry, but maybe I didnt get the requirement correctly. Why cant you just create 3 ranges in your radial gauge and set the start and end for each range appropriately? And you can set the color for each range individually as first range should be green, second range should be yellow and third range should be red Cheers, Jason | www.SqlJason.com P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :) Hi Jason, You are right. This workaround works perfect. Thank you for sharing. Regards, Charlie LiaoCharlie Liao TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
November 15th, 2012 7:59pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics