Pagination

1) This article showcase the process to utilize conditional formatting to control pagination. You will see 2 common usage scenarios: fixed number of rows per page and pagination by group.

2) The settings only take effect in the pagination preview.

3) Prerequisites: Insert Data Columns, An Introduction of Conditional Formatting.

1. Create a new dataset [ds1]

1) Create a new DB query dataset.

2) Drag the table [Product] into the DB query.

2. Drag data columns into cells

1) B3~E3: Drag data columns [Product_name], [SupplierID], [Inventory_quantity] and [Order_quantity] into cells.

2) B2~E2: Enter headers and fill them with grey.

3) B2~E3: Set as center alignment and add borders.

4) Data setting of B3: List.

5) Preview.

3. Select B3 and add condition

4. Property setting

1) Click + to select the property: Pagination.

2) Pagination options: No Pagination, Paginate After Row, Paginate Before Row, Paginate After Column, Paginate Before Column (if you select No Pagination, the page will remain unchanged).

3) Select Pagination After Row.

5. Add formula condition

Enter the formula: &B3 % 15 == 0

Note1:&B3 is the row number of data extended from B3.

Note2:% means to take the remainder.

Note3:By setting the conditional formatting, Pagination After Row will be enabled when row numbers are multiples of 15.

6. Select Pagination Preview

Pagination every 15 rows

7. Duplicate header rows

1) Press and hold the [Shift] key to select the first and second rows, right click and select [Set Duplicate Header Rows].

2) Preview. The header row is repeated on each page.

8. Empty some settings

1) Delete the conditional formatting of B2 and modify its data setting to Group

2) Preview. Data will be grouped by product.

9. Add the conditional formatting for B3

1) Property: Pagination.

2) Select Paginate After Row.

3) There is no need to add any condition.

4) Preview. Each page shows only the data of the same product.