Get rid of page breaks in report

How do I get rid of the page breaks in an SSRS report, making the report display in a single page?

Solution 1:

Open the report's .rdl file in a text editor and locate the <Page></Page> section. In that section, insert the following:

<InteractiveHeight>0in</InteractiveHeight>
<InteractiveWidth>8.5in</InteractiveWidth>

In SSRS, an interactive height of 0 means the report has an infinite length and therefore, it will exist on a single page.

Solution 2:

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.

Solution 3:

Right Click anywhere in Body and select Properties.

select Reports From the DropDown. (When you select an element in report, the dropdown changes to TextBox/Header or the item you select)

In Report properties, Expand InteractiveSize Attribute.

Set Height -> 0in

Solution 4:

If you're trying to display report data in one page, it is simple to do in SSRS. All you have to do is select an entire table and then go to the property pane. Update KeepTogather = True.