Search code examples
reporting-servicesssrs-2008ssrs-2008-r2ssrs-2012ssrs-tablix

SSRS - How can I group fields all into 1 column?

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

Solution

  • 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.