# Pagination Pagination refers to the organization of content into pages, usually with page numbers, in order to make it easier to read and navigate through the document. This also allows for easy printing and distribution of the report. In this section, let's discuss the single & multi-page options, pagination controls and page breaks. ### 1. Number of pages a) In the 'Design' tab of the toolbar, you can find two options - ‘Single page’ and ‘Multi pages’.

### i) Single page 'Single page' displays all the rows on a single page with a scroll, if needed. In the below image, you can see '50' rows are displayed on a single page.

### ii) Multiple pages By using the 'Multi pages' option, you can automatically display the rows that fit on a single page and split the report into multiple pages. In the below example, you can see that the table gets split into two pages.

### **iii) Pagination controls** When using the 'Multi pages' option, the following details are displayed in the status bar - Total rows, scrolling options to the first, last, previous and next page and count of rows displayed on the page.

You can also turn off pagination from the footer. Click on the six-dots icon as highlighted in the image. In the footer context menu, you can see the 'Hide pagination' option. You can see that the option is turned off and the report has two pages.

If you turn on the 'Hide pagination' toggle, pagination is removed and you can see all the rows displayed on the same page along with a scroll.

### 2. Page breaks Instead of the default option of splitting a report by the number of rows that fit on a single page, you can split based on the row/column hierarchies. To achieve this, you can use row, column and section breaks. They are useful when you want to control the layout of the report, especially when there are multiple row and column hierarchies. They are available under the 'Design' tab of the toolbar in the 'Page breaks' section. Let's look at the three options one by one.

### i) Row break The 'Row break' option allows you to add a break based on a row hierarchy. To enable the ‘Row break’ option, you need to have at least 2 levels of row hierarchy. All the row hierarchies are listed in the dropdown.

* Data-driven row break Let's insert a row break for ‘Category’. Select 'Category' from the drop-down.

You can now see each category for a region and sub-region on a separate page.

* Custom row breaks You can override the data-driven options for creating page breaks and insert a page break at any point in the report. This can be accomplished using break rows. Select the row in the report where a page break has to be inserted. From the Insert ribbon, 'Insert Row' dropdown, select the 'Break Row' option.

An empty row is inserted above the selected row. Notice that the break row is greyed out.

Navigate to the Design ribbon. The 'Break rows' option is now enabled in the 'Row Break' dropdown. Select this option to insert page breaks based on break rows.

Notice that a page break has been created at the specified point in the report and the remaining data has been shifted to the next page.

### ii) Column break The 'Column break' option allows you to add a break based on column hierarchy. To enable the ‘Column break’ option, you need to add at least one field in 'Columns'. Let's insert a column break for ‘Quarter’. Select 'Quarter' from the drop-down.

Each quarter is shown on a different page. Since there is no row break applied, the rows are split such that they fit on a page.

### iii) Section break The 'Section break' option allows you to split the table into different portions on the same page. The section break is enabled only if * there are more than two row hierarchies and * row break is not applied based on the lowest row hierarchy

Let's insert a section break for ‘Category’. Select 'Category' from the drop-down.

A blank row is inserted above each category as shown.

{% hint style="info" %} To remove the row/column/section breaks, you can select the ‘None’ option from the respective drop-down. {% endhint %} In the next section, we'll look at adding a [header and footer](/working-with-inforiver/8.-paginated-reporting/header-and-footer.md) to the report. **Resources** [Paginated reporting in Power BI](https://inforiver.com/paginated-reports-powerbi/) --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.inforiver.com/working-with-inforiver/8.-paginated-reporting/pagination.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.