Output
Page Break
Starts a new report page whenever a column's value changes — a page per region — or every N rows, with the value as the page's heading.
When to use it
Use it before Report Table in reports that are printed or saved as one section per group.
In a pipeline
Sort RowsPage BreakReport TableHTML Report
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| New page | select | — | change |
| Column | select | — | Region |
| Rows per page | number | — | 50 |
Example
A page per region
- New page=When a column's value changes
- Column=Region
| Region | Customer |
|---|---|
| East | Cole & Sons |
| West | Harbour Foods |
| West | Northwind |
| Region | Customer |
|---|---|
| East | Cole & Sons |
| West | Harbour Foods |
| West | Northwind |
Worth knowing
- Sort by the column first: a page starts every time the value changes, not once per value.
- Pages break when the report is printed (Layout: Print in HTML Report); on screen each page is its own titled table.
- The marks are internal columns, so nothing else in the flow changes.