Search code examples
sql-serverreporting-servicesssrs-tablix

Is there any way to prevent a group from taking up multiple rows?

I have a parent group, a child group, and child group of the first child group. From the images below, you can see that each group takes up multiple rows and it's taking up a lot of unnecessary space when running the report. Is there any way to make them not take up additional rows like that?

enter image description here enter image description here enter image description here

Solution

  • Method 1

    1. Delete the 3 columns on the left without deleting the groupings.

    2. Delete the top 3 rows without deleting any groupings.

    3. Right click on remaining cell and insert 3 columns to the left.

    Method 2:

    1. Split the Cells in Region, Area and Location by right clicking.

    2. Delete the top 3 rows without deleting any groupings.