Disable page breaks in SQL Reporting Services (SSRS)

In some situations you may wish to disable page breaks in SSRS report, such as when displaying report as part of web page (for example, inside SharePoint).

To do this, you need to set Interactive Height to 0.

Select Report Properties, and go to InteractiveSize property. Change height to 0. You’ll get a message saying “Setting interactive height to 0 may have a performance impact.”. Click OK to close the message. Save your report and run it – page breaks are now gone.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s