I've looked at previous questions in this forum, in particular this one, and not been able to find a solution. I have a simple table initially created with the wizard and a detail group added to deepest child group. [[Year] [[Month] [[Country] [[Detail1] [Detail2] |[Sum(Amount)] [Year [Month [Country = Group1 What I find is that when I collapse any of my [Year], [Month] or [Country] groups, the table still displays the first detail row group. I've tried adding a Total below my detail group "=Group1" and setting Row Visibility to Hide; this partially works by only hiding my first detail group column [Detail1] but leaving [Detail2] visible. This simplified example has only two detail columns; however in my report I have 20 or more. I set Row Visibility to Hide as I would like to avoid showing an additional row for each group. Perhaps I am missing something but does anyone know how I can display the detail data only if the groups are not collapsed?

In the example above, did you you add your 2nd, 3rd and 4th columns into a detail group?

In the example above, did you you add your 2nd, 3rd and 4th columns into a detail group?

Hi Blair, I have tested it on my test environment, however when I collapse a parent group, all of its child group are not displayed. Here has a screenshot about the result. In Reporting Services, if we want to set the visibility of a group, we can click the name of the row group or column group for which you want to hide the associated rows or columns in the appropriate group pane. For more information about how to add a visibility toggle to an item, please see: http://msdn.microsoft.com/en-us/library/ms156456(v=sql.100).aspx If the issue persists, please elaborate the structure of your tablix, if possible provide a screenshot of the report to us so that we can make further analysis and help your out. Regards, Charlie Liao

Hi Blair, I have tested it on my test environment, however when I collapse a parent group, all of its child group are not displayed. Here has a screenshot about the result. In Reporting Services, if we want to set the visibility of a group, we can click the name of the row group or column group for which you want to hide the associated rows or columns in the appropriate group pane. For more information about how to add a visibility toggle to an item, please see: http://msdn.microsoft.com/en-us/library/ms156456(v=sql.100).aspx If the issue persists, please elaborate the structure of your tablix, if possible provide a screenshot of the report to us so that we can make further analysis and help your out. Regards, Charlie Liao