Page Borders button in the Layout group on the Page Layout ribbon tab. The active report sheet displays page breaks as a dotted line.Page breaks and borders can be set up only for sheets of regular report opened for edit.
To view borders of the sheet pages output for print and/or export, click the Page Borders button in the Layout group on the Page Layout ribbon tab. The active report sheet displays page breaks as a dotted line.
Page borders are set depending on the determined page orientation and size.
To display particular sheet data on one page, set up vertical and horizontal page breaks. To do this:
Put the cursor to the cell that will be the top left cell of a new page border.
Click the 
Breaks button in the Page Settings group on the Page Layout ribbon tab.
Select the Insert Break item in the drop-down menu of the Breaks button.
After executing these actions, page breaks are displayed as a solid line for the active report sheet. In this case page borders are also displayed.
NOTE. On adding a custom page break, automatic sheet division into pages is set depending on page settings and page margins.
It is available to add several page breaks to one sheet.
To remove page breaks:
Put the cursor to the cell that is the top left cell of the page break.
Click the Breaks button in the Page Settings group on the Page Layout ribbon tab.
Select the Remove Break item in the drop-down menu of the Breaks button.
After executing these actions the current page break is removed.
To remove all page breaks:
Click the Breaks button in the Page Settings group on the Page Layout ribbon tab.
Select the Reset Page Breaks item in the drop-down menu of the Breaks button.
After executing these actions all page breaks are removed. Automatic page division depending on page settings and page margins is restored for the report sheet.
Consider an example of the report sheet, for which page breaks are displayed:
As it is seen from the figure, the automatic vertical border (dotted line) is displayed between the J and K sheet columns.
Set page breaks for this sheet in such a way that the second data area is located on a separate page during print or export. To do this:
Put the cursor to the H0 cell that will be the top left cell of page border.
Click the Breaks button in the Page Settings group on the Page Layout ribbon tab.
Select the Insert Break item in the drop-down menu of the Breaks button.
The report sheet with set page breaks looks as follows:
On print and/or export, data areas located on the report sheet are output on separate sheets:
TIP. If data width and/or length is too large to fit one page, set up displaying of pass-through columns and/or rows.
See also:
Setting Up Report for Printing | Using Table Sheet | Using Text Sheet | Working with Ready Reports