SSRS 2008 2 Column Groups visibility issue
I have a report in SSRS 2005 with 2 column groups (parent child like) in a matrix and i use to hide child group based on values of a parameter but once i upgrade to SSRS 2008 it is not working correctly. Now either both groups are visible or both are hidden.
July 22nd, 2010 6:33pm

The conversion from 2005 to 2008 probably messed up the Visibility properties. I would all your Visibility settings then SAVE the report. Then re-define the one(s) you want. In 2008, the Matrix control and the Table control have been replaced with a "Tablix". Thank you Redmond, WA! </sarcasm>Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.
Free Windows Admin Tool Kit Click here and download it now
July 22nd, 2010 6:59pm

Hi Pankaj, The visibility property for a column in SQL Server Reporting Services(SSRS) 2008 is big different than the property in SSRS 2005. In SSRS 2008, we need to change to "Advanced Mode", and then hide the column or group. For more informaiton, please see: Report Design: Shrinking Hidden Static Table Columns: http://blogs.msdn.com/b/robertbruckner/archive/2010/05/02/report-design-shrinking-hidden-static-columns.aspx Please feel free to ask, if you have any more questions. Thanks, Jin ChenJin Chen - MSFT
July 23rd, 2010 9:09am

Thanks that helped me too.
Free Windows Admin Tool Kit Click here and download it now
February 22nd, 2011 2:28pm

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

Other recent topics Other recent topics