Simple pagination is not so simple

Hi RobGMiller,

As per my understanding, you want to set each customer group to start at the first line of a page, you set KeepTogether to true for the groups, but page break does not work properly.

In Reporting Services, we 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. To add a page break to a row group in a table, please refer to the following steps:

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


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. 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.

In addition, in Reporting Service, the physical page size is the paper size, and the default PageSize is 8.5 x 11 inches. If the report body grows past the right edge of the physical page, then a page break is inserted horizontally. If the report body grows past the bottom edge of the physical page, then a page break is inserted vertically. The PDF renderer is a physical page renderer, it is usually recommended that we select the target group and set the "Keep Together" property to "True". This can avoid page break within an instance of a group in some cases.

For more information about Pagination in Reporting Services, please refer to the following document:

http://ift.tt/1FzQMhU

If you have any misunderstanding, please feel free to let me know.

Thanks,

Wendy Fu

If you have any feedback on our support, please click here.