Disable all page breaks in SSRS

Posted by on October 6, 2015 No comments

There could be scenarios where we would like to remove all page breaks for a report and just would like to see all records in one single page.

Here are the steps :

  • Check all individual tablixes have pagebreak to be disabled

No_Page_breaks_1

  • On the report properties set interactivesize for height  = 0 (an interactive height of 0 means the report has an infinite length)

No_Page_breaks_2

  • You will get a warning that it might be non-performant and be aware of consequences if the dataset is returning massive rows.

No_Page_breaks_3

Other alternative option is to open the report solution XML i.e RDL file in BIDS and look for <Page></Page>  sections in entire RDL file and then insert below code

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

Disclaimer: Non HTML rendering is NOT supported