Export (0) Print
Expand All

Adding Page Breaks

SQL Server 2008

In a report, you can specify where to create page breaks. A page break divides a report into separate pages for viewing and printing. Page breaks are not added by default.

Page breaks can be added on report items and data regions. In a table, matrix, or list, page breaks can be set before, after, and between groups. Page breaks for tables with no groups can be set based on an expression, for example, you can set a page break after every 20 rows.

For more information, see How to: Add a Page Break (Reporting Services) and Expression Examples (Reporting Services).

A report renderer uses page breaks to determine how the report content fits on each page. A page differs for each type of renderer. For the Excel renderer, a page is a worksheet. For the PDF renderer, a page is the physical page. For the HTML renderer, a page can be the whole report.

For the HTML renderer, adding page breaks can improve the performance of large reports when they are run and viewed in Preview mode or on the report server. A rendered page is displayed while the rest of the pages are rendered in the background. This allows you to begin viewing the initial pages of the report while waiting for additional pages to become available.

If you expect most of your users to view a report in a specific format, set page breaks that work with that renderer. For more information, see Available Rendering Extensions (Reporting Services) and Understanding Pagination in Reporting Services.

Community Additions

ADD
Show:
© 2015 Microsoft