On the Home tab, in the Paragraph group, click Show/Hide to show all formatting marks including page breaks. Double-click the page break to select it, then press Delete.
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. Show activity on this post.
Go to Home > Click the Show/Hide button to display all non-printable hidden marks like page breaks, spaces, and non-breaking spaces in the document. Double-click to select a page break and press Delete to remove it. You can now click the Show/Hide button again to hide the other formatting marks in the document.
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.
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.
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
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.
You can set the report's InteractiveHeight to 0 to disable paging.
Go to report properties -> Page -> InteractiveSize -> Height. Set this value to 0in.
Here is the similar question.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With