Is it possible to hide the columns of row groups in a matrix? I have a report with a 4 level cascading hierarchy of row groups. The initial state has the parent visible and all child groups hidden. This works fine. But theres a massive space between the parent group cell label and the data cells ie +Parent .........................................................|data it looks fine when expanded -Parent..........................................................|Data ..............-Child1.............................................|Data ............................-Child2...............................|Data ..........................................-Child3.................|Data But when collapsed I want it to look like +Parent..|Data and have the data rows move right/left depending on the level that im on. I've tried changing the visibility of the 'Static' placeholders for the row groups but that either doesn't do anything or just hides a single cell Is this possible?

Hi There Please follow these steps Drop a matrix inside your reportPlease put Child3 in the row group, and Data Amount in the details Now you need to create a parent group for to Child2. In order to create a parent group, please click on Row Groups pane, right-click the Child3 group, select Add Group, then select Parent Group. I have shown this in the screenshotNow you need to create a parent group for to Child1. In order to create a parent group, please click on Row Groups pane, right-click the Child2 group, select Add Group, then select Parent Group. I have shown this in the screenshot Now right click on your child1 and child2 column and delete them Im putting some screenshot for your help add your child1 and child2 just above child3 I have again shown this in the screenshot and now you can hide the visibility of your child3 and child2 based on Many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful

Hi, I think I didn't explain myself properly. I have my cascading groups and visibility working fine, but the hidden rows leave empty space above when they're hidden. And I want to retain my formatting when everything's expanded The behaviour I'm aiming for is: +Parent..|Data when expanded goes to this -Parent................|Data ..............+Child1..|Data when expanded goes to this -Parent..............................|Data ..............-Child1.................|Data ............................+Child2..|Data when expanded goes to this -Parent..........................................................|Data ..............-Child1.............................................|Data ............................-Child2...............................|Data ..........................................-Child3.................|Data etc.. In my solution my parent, child1,2,3 are all in different columns

Hi There I think I have understood your requirement and to my best knowledge this is best possible solution for your requirement. Otherwise you end up with lot of column spaces when you hide your column as you are experiencing now. If you use your approach you end up with lot of spaces. I hope this will help. Please let me know if you have any questions Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Hi Jakubk, From your description, you want the column that contains the child group to be hidden either when the parent group is collapsed in the drilldown report. As per my understanding, its not supported in Reporting Services currently. When we add a toggle to a textbox, the textbox must share the same scope as the hidden item or is in a scope that contains the hidden item. In this issue, the columns that contains the child groups are in different scopes with the textbox that contains the parent group. Based on your scenario, I think Syeds suggestion is the closest approach. To make the groups hierarchy be explicit, you can reset the Padding property of the corresponding textbox for each group. The report looks like below: For more information about the scope, please see: Calculating Totals and Other Aggregates If you have any questions, please feel free to ask. Regards, Charlie Liao

Is it possible to hide the columns of row groups in a matrix? I have a report with a 4 level cascading hierarchy of row groups. The initial state has the parent visible and all child groups hidden. This works fine. But theres a massive space between the parent group cell label and the data cells ie +Parent .........................................................|data it looks fine when expanded -Parent..........................................................|Data ..............-Child1.............................................|Data ............................-Child2...............................|Data ..........................................-Child3.................|Data But when collapsed I want it to look like +Parent..|Data and have the data rows move right/left depending on the level that im on. I've tried changing the visibility of the 'Static' placeholders for the row groups but that either doesn't do anything or just hides a single cell Is this possible? This behaviour is by design and you cannot change in any of current versions of SSRS !Rajkumar Yelugu

Thanks guys, I didn't think it was possible doing it the way I was trying because of the scope I'm a bit confused on how I can use te padding to shrink/increase the width of the column when I use Syed's suggestion. Or is the suggestion to still have a static width row group column but instead of there being4 columns there is now just 1 that is much narrower than the sum of the 4 columns & I use custom padding values for each level to show the hierarchy? Thanks

Hi There You are getting there. Yes this is what I mean. You just create one column and put some padding from left from you second group onward by going to textbox properties and alignment. The width of this column is almost same of your first column as you are putting some padding so you can add padding on top of that. You can see from my post above the image look very tidy Please let me know if you have any questions Many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful

ok cool, cheers for the info everyone. I think i'll end up going a similar way but keep them as separate columns like so. Just needed to set the static column that's working as the 'indent' to have it's visibility toggled by its own group (ie column to the left of child1 is toggled by Parent and so on)