Simple design layout question

I have a bunch of reports that have 2 or 3 groups.  I am interested in having the left hand columns for each group overlap a bit to save on horizontal space within the report.  The standard SSRS layout is:

Group1

             Group2

                           Group 3

I want it to look more like this:

Group1

   Group2

      Group3

I can do this by placing them all in the column for the innermost group and using a formula with spaces and then collapsing the left columns to nothing to do this, but I was wondering if there was another (easier) way.

Thanks.

Daniel,

Yes there is a way to do this. You just have to add a row group above. Right Click on your Group3 and Add a new Row Group above.. This is where you would put the Group2. You do the same for Group 3. Then in each one you just set the LEFT spacing accordingly.

An example is here:

http://www.bidn.com/blogs/kylewalker/ssis/657/how-to-create-a-single-column-multiple-group-grouping-in-ssrs

Brian

Thanks for your quick response Brian.  This is not all that different that what I am already doing.  I don't insert the row, rather I just use the existing row for each group, but move the group data over to the innermost column.  Your blog certainly laid it out better than my question ( I have trouble with uploading pictures in the forums).

You also mention deleting the unused outer columns.  I have run into a bug doing that in that it seems to destroy repeating header rows on each page, so rather than delete I just slide the width down to zero for the unused left most Group columns.  I have found I must set up my repeat on new page settings early on in the report design, and then if I delete or merge columns I get into trouble and the repeat on new page settings seem to break.  I have found many forums that list this as a bug, so I tread very carefully around this problem.

You're welcome. Just note thought that I didn't write that blog. It was a colleague of mine. :) I've written other blogs that performed similar steps, but not laid out in the same way that he did. As far as the bug... you are right... I've come across similar issues as well.