SSRS report , get rid of page breaks in report

Question

Hi,

How do i get rid of the page breaks in the the SSRS report, making the report display in a single page.

Thanks in advance, anna

Answer 1

Make sure you do not have one of the properties set to true on one of your report items for PageBreakAtEnd or PageBreakAtStart. Also, make sure you keep the width of your report less than the width of your actual paper, keeping in mind extra space for the page margins (Report > Report Properties > Layout)

And according to Microsoft: "Although it is not recommended, you can disable soft page breaks by setting InteractiveHeight to 0." I think this only works for HTML rendering though, I have not used it myself.

I'm not sure if there is a scale of any kind where no matter how big your report is it still prints on one page if that is what you are looking for.

Answer 2

Dustin Brooks wrote:

Also, make sure you keep the width of your report less than the width of your actual paper, keeping in mind extra space for the page margins (Report > Report Properties > Layout)

Also be extra careful about this when working with subreports. I've lost count of the times I ended up with extra blank pages when I've accidently made a subreport wider than the main report.

Answer 3

When creating reports for the web, I would disable page breaks by setting the InteractiveSize to something really crazy, like 1000x1000". (I just checked, and setting it to 0x0" as Dustin Brooks mentioned in his answer has the same effect.)

I left the PageSize property at 8.5x11" and the reports printed across multiple pages normally.