Add a Page Break (Report Builder and SSRS)

  • Article

You can add a page break to rectangles, data regions, or groups within data regions to control the amount of information on each page. Adding page breaks can improve the performance of published reports because only the items on each page have to be processed as you view the report. When the whole report is a single page, all items must be processed before you can view the report.

Note

You can create and modify report definitions (.rdl) in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items. For more information, see Designing Reports in Report Designer and Report Builder (SSRS) on the Web at microsoft.com.

To add a page break to a data region

  1. On the design surface, right-click the corner handle of the data region and then click Tablix Properties.

  2. On the General tab, under Page break options, select one of the following options:

    • Add a page break before. Select this option when you want to add a page break before the table.

    • Add a page break after. Select this option when you want to add a page break after the table.

    • Fit table on one page if possible. Select this option when you want the data to stay on one page.

To add a page break to a rectangle

  1. On the design surface, right-click the rectangle where you want to add a page break, and then click Rectangle Properties.

  2. On the General tab, under Page break options, select one of the following options:

    • Add a page break before. Select this option when you want to add a page break before the rectangle.

    • Add a page break after. Select this option when you want to add a page break after the rectangle.

    • Omit border on page break. Select this option when you do not want a border on the page break.

    • Keep contents together on a single page, if possible. Select this option when you want contents inside the rectangle to stay on one page.

To add a page break to a row group in a table, matrix, or list

  1. In the Grouping pane, right-click a row group, and then click Group Properties.

    Note

    Page breaks are ignored on column groups.

  2. On the Page Breaks tab, select Between each instance of a group to add a page break between each instance of a group in the table.

  3. Optionally, select Also at the start of a group or Also at the end of a group to specify that a page break be added when a group starts or ends in the table.

See Also

Concepts

Pagination in Reporting Services (Report Builder and SSRS)

Rendering Behaviors (Report Builder and SSRS)

Page Headers and Footers (Report Builder and SSRS)