Get rid of page breaks in report

reporting-services page-break
san picture san · Jan 20, 2009 · Viewed 88.7k times · Source

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

Answer

kinshowa picture kinshowa · Dec 9, 2012

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.

Related questions

The permissions granted to user ' are insufficient for performing this operation. (rsAccessDenied)"}

I created a report model using SSRS (2005) and published to the local server. But when I tried to run the report for the model I published using report builder I get the following error. Report execution error:The permissions granted …

Read More
How do I format date and time on ssrs report?

on SSRS report I need to show todays date and current time i tried this =FormatDateTime(Now,"MM/dd/yyyy hh:mm tt") but this is not working for me giving an error. Anyone please help me for expression ? I …

Read More
SQL variable to hold list of integers

I'm trying to debug someone else's SQL reports and have placed the underlying reports query into a query windows of SQL 2012. One of the parameters the report asks for is a list of integers. This is achieved on the report …

Read More