CODEWITHSUNDEEP
reporting-servicesssrs-2008ssrs-2008-r2ssrs-2012ssrs-tablix
Juan Velez
Juan Velez

Reputation: 741

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

Upvotes: 0

Views: 344

Answers (1)

alejandro zuleta
alejandro zuleta

Reputation: 14108

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.

Upvotes: 1

Related Questions