SSRS - Blank Pages (again...) even with respected settings

0
votes

I know that the question was submitted a lot of times, but this is driving me mad.

I'm trying to make a landscape A4 report, printer friendly. As I could see in lots of threads before I tried to respect the fact that the body size must be inferior or equal to the physical page, including margins, and columns in the count.

Here are my document properties

Report:

reportproperties1

reportproperties2

Body:

bodyproperties

I inserted a first rectangle with some contents, at that point, no extra blank page, here is the rectangle location :

rectangle1properties

Right after I inserted a second rectangle with same dimensions as previous one:

rectangle2properties

Both first pages are rendered correctly with the rectangle at its expected location, but I get a 3rd extra blank page...

ConsumeContainerWhiteSpace property is set to true, and this did not help...

Do you have any trick to get definitely rid of these blank pages ?

Thanks a lot !

EDIT : Just added the report designer view, as requested

reportdesigner1 reportdesigner2

2
reporting-services
Could you maybe provide a picture of the design view? Also, have you removed any excess space between the bottom of the second rectangle and the bottom of the report? – Pants
Just added the two pictures below the original post. Even with the space removed between rectangle #2 and footer, I get an extra blank page after first rectangle, and a second extra page after second rectangle. – Gore Gonzola
Your margin is set to zero.Try setting a narrow margin (say 10mm) and then reducing the width and height of the content by 20mm. Depending on your scenario, the renderer will look at the default printer settings and if zero margins are not supported, it will try to fit within the constraints of the printers limits. You could also try to reduce the width or height of the content significantly and if the blanks go away at least you'll know if the content height or width that;s the issue. – Alan Schofield
Tried this as well, but no luck... That's really not good, cause the product itself is really nice, to build the queries,etc, but when it comes to printing stuff... – Gore Gonzola

2 Answers

0
votes

Don't know how I didn't notice it before, but your body height is bigger than your page height defined in the report properties. If your report is supposed to generate two pages, that second page will have to add an extra 3 centimeters and cause that third page.

enter image description here

0
votes

I finally managed to handle this the following way : I put my first rectangle 0,5cm under the header (with a forced pagebreak after) and if I use the same size of rectangle for everypage, ensuring that there's a 0,5 cm space between each rectangle, I can manage to display content on multiple pages, with rectangle bordel always located at the same position. Guess I should keep this method for all future reports :) Thanks a lot for your advices !