I have a SSRS 2008 R2 report with a Tablix. One of the columns in the tablix needs to be displayed as a Red/Yellow/Green indicator. I have a Gauge Panel with a ThreeUnrimmedTrafficLights indicator in this column. The problem is that one of the other columns needs to grow when needed to display all the text and when that happens the row height changes and the Gauge Panel then also resize which means the indicator now looks bigger. I do not want this to happen. The indicator needs to stay the same size. Any ideas of how I can force the Gauge Panel to not grow with the row height? Thanks

Hi, This is by design behavior that the indicator Gauge Panel resizes proportionally with the Tablix cell growing in the current reporting services. However, there are 2 workarounds as follows for your reference: Workaround 1) In the cell, insert a Rectangle and put the indicator gauge panel on it. Workaround 2) New a report to display these indicators. Then, on the main report, we can insert a subreport control in the Tablix cell to reference this new report. The 2 workaround can keep the indicators's size same in the report, however, their allignment is always at top, can't be formatted in middle. Additionally, if you have any concern about this, please submit a feedback at http://connect.microsoft.com/SQLServer/Feedback and hope microsoft improve this feature in the next service pack or product release. thanks, Jerry

Jerry Thanks so much for the quick response and easy solution. I used the Rectangle workaround and it works great. I will add feedback on connect. Thanks Ignus