Skip to main content

SSRS Reports - Space/Gap issue between the objects in SSRS Reports


In Reports where some objects are set to be shown/hide based on some expression/filter condition etc.

There Could be some white space issue between the objects on the report( i.e. when few objects are hidden in the report, the white space between the objects will accumulate and displayed as a big gap between the objects on the report).

Following are few ways using which we can handle this kind of issue:
1. Remove the Gap between the objects in the report layout.
2. Or put a text box and make the border the same as the background color and apply the same show/hide action on it.
3. If you are using a table/matrix then instead of putting the space between objects, just add one static row above the column header for the table/matrix and make the border color the same background color.

below is one approach:

The report before any space handling:
-----------------------------------------------------------------------------

Report Preview when all the objects are set to visible


Report Preview when the objects was hide

after using the Text Box:

Adding a text box in the layout below the table which is set to show
and hide with the same show hide property


Report Preview after the objects hidden

Comments

  1. This has been an issue we face. Irregular gaps the space between subreports. Thanks for sharing this.

    ReplyDelete
  2. Hi,
    I am facing following issue, Your help is appreciated.

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4f91857b-a154-49cd-91fb-5d04cce6cd4e/white-space-issue-if-we-have-series-category-in-bar-chart?forum=sqlreportingservices

    ReplyDelete
  3. Hi,
    I am creating fully dynamic ssrs report in which it contains 70 different dynamic sections also their position shuffles. Normally in ssrs report viewer its looks good but after download it in PDF format there is lots of unnecessary gaps are there. How i can adjust all of that.
    Please share your views about it.

    ReplyDelete
  4. How to put space between two rows and columns of a matrix report.Any help on this?

    ReplyDelete
  5. Thanks and I have a dandy give: Who Does House Renovation house renovation for sale

    ReplyDelete

Post a Comment