HELP! Report Builder Page Overflowing Into the Next

razaross — Sat, 16 Oct 2021 21:24:00 GMT

I'm using the latest Power BI Report Builder (v 15.7.1704.1) and I'm stumped.

I have a dataset where I want a page printed PER ROW. So each page represents a bunch of data for one row using a freeform tablix (list).

* Report: inches, landscape, 11 x 8.5, no margins

* Header: none

* Body: 11 x 7.5in

*Tablix: 11 x 7.5in; Location 0,0

*Tablix Rectangle: 11 x 7.5 in; Page Break Location: End

* Few elements inside the tablix rectangle that I'm positive does not exceed 11 x 7.5

* Footer: 0.5in

Zero margins on everything.

From this layout, the height of body and footer would equal 8 in. However, I want to use the remaining 0.5 inches of the height of the page that should be available. When I increase the Body, Tablix (and its rectange) to 8 inches in height, each page overflows into the next. I can't figure out what is using the remaining 0.5 inches of the page to cause this.

At one point during report design, I did have a header, but have deleted it and made sure the Tablix location was 0.0 in the body. I looked at the RDL markup thinking something might still remain of it or there was something that shouldn't be there, but everything I see has a name that I explicitly assigned to elements that should be there and I've done all the math on these.

Ideas? Is there something fundamental about limitations of the report page I don't understand? TIA for your help.

Re: HELP! Report Builder Page Overflowing Into the Next

Anonymous — Tue, 19 Oct 2021 06:38:55 GMT

Hi razaross ,

Please review the method in the following links and check whether they can help you resolve the problem.

Avoid blank pages when printing paginated reports

Report body width <= Report page width - (Left margin + Right margin)

How to get rid of blank pages in PDF exported from SSRS

> Set the report property called ConsumeContainerWhitespace to True (the default is false)

> Change the page units to Inches

Best Regards

Re: HELP! Report Builder Page Overflowing Into the Next

razaross — Mon, 25 Oct 2021 18:31:25 GMT

The "ConsumeContainerWhitespace" setting did the trick. Thanks!

topic Re: HELP! Report Builder Page Overflowing Into the Next in Developer

HELP! Report Builder Page Overflowing Into the Next

Re: HELP! Report Builder Page Overflowing Into the Next

Re: HELP! Report Builder Page Overflowing Into the Next