Disable all page breaks in SSRS

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

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>