How to use page breaks in Word when using a repeater?

How to use page breaks in Word when using a repeater?

FIRST CREATED ON 6 Oct 2025 I AUTHOR Emma Camacho

This is an example of the use of Page Breaks in Word when using repeaters. 

The output is a Report that shows all the Sales Reps from a specific Region. It should look like this:



The template looks like this:



The important part is to have a Condition Element surrounding the Page Break, otherwise there will be an empty page at the end of the Report.

To achieve this, a Conditional Element, 2 Local Variables and Preparation Actions in the Sales Rep Name Expression Element are used. The local variables' definitions are below



The Counter will be increase by 1 after each repetition.

Counter=1

The total number of Sales Reps is needed in the Condition Element, it will be compared to the Counter to show or hide the page break.


TotalSalesRep = [Datasource].[Executive Dashboard].[Expression].[count(distinct [Sales Rep Name])]


The Counter is increased by 1 in the preparation actions of the Sales Rep Name Expression Element that is displayed.



The Condition Element has the following Condition



[LocalVariable].[Counter] <= [LocalVariable].[TotalSalesReps]


Looking for Additional Guidance?
If you require more detailed information or further assistance, please visit our comprehensive Online Documentation. Our resources are designed to help you navigate all features and functionalities effectively.