CODEWITHSUNDEEP
reporting-servicesssrs-2008-r2
SSMSJ
SSMSJ

Reputation: 219

SSRS remove space between rectangles

I have a report with three rectangles and a tablix inside each, I'm using the rectangles to create page breaks so when I export to excel I have three named tabs for each tablix, however because I cannot eliminate the space totally between rectangles row one in tabs two and three in excel are blank rows. Is there anyway of removing the space totally?

Upvotes: 1

Views: 3091

Answers (2)

SSMSJ
SSMSJ

Reputation: 219

Select all and select Remove Vertical Spacing in tool bar. Doh

Upvotes: 1

Hannover Fist
Hannover Fist

Reputation: 10860

It sounds like you are putting the page break at the end of the rectangle. Any space after that will show as a row before the next table.

Put the page break at the Start of your 2nd and 3rd tables.

enter image description here

Upvotes: 2

Related Questions