Search code examples
sql-serverreporting-services

SSRS- How can I eliminate page breaks within an email body?

I have several SSRS '08 reports that look great when viewed as a web page or exported to the various formats. Recently, someone wanted a data driven subscription to go out for the report. No problem. They were adamant that they did not want the report attached to the email or to link to the report from the email. No problem. Unfortunately, the email body containing the report contents has page breaks at regular intervals. That is a problem.

Is there a way to conditionally have page breaks, so that I can prevent them from showing up in the email?

Solution

  • The MHTML rendering extension (probably the one you're using if you're embedding reports in emails) supports the disabling of soft page breaks using the "interactive height" report property.

    Have a peek at this question for more details:

    Single page display in HTML rendering : SSRS