0

I have an SSRS report which looks something like this:

enter image description here

I used Row Groups to get the above layout but I need to get the layout to look like the below image. So basically I need the Groups and Sub Groups to all be in 1 column. Is this possible to do in SSRS?

enter image description here

Juan Velez
  • 741
  • 5
  • 15
  • 29

1 Answers1

1

There is a way to achieve your expected result by playing around with the grouping settings.

First create a tablix and right click on the second cell of the first column.

enter image description here

Select Add Group, Row Group - Parent Group. Then just use the following settings.

enter image description here

Be sure to check Add Group Header checkbox.

Now select the recently created group column (the first) and delete it. Note the groups will remain.

enter image description here

Once you delete the column you will have two rows in one group. Just use the exprressions and set the bold format for the Group cell.

enter image description here

It will produce the following output.

enter image description here

Let me know if this helps.

alejandro zuleta
  • 13,962
  • 3
  • 28
  • 48
  • That worked perfectly! I actually had to add a second subgroup so there were 3 levels. I had to play around with the grouping a little bit to add the 3rd level but I was able to do it using your instructions. Thanks! – Juan Velez May 23 '16 at 22:16