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??

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

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

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

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! :)

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.

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