How to use page breaks in Excel when using a repeater (same sheet)? (1/2)

How to use page breaks in Excel when using a repeater (same sheet)? (1/2)

FIRST CREATED ON 24 Jun 2026 I AUTHOR Emma Camacho

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

The output should look like this:





Each page will have 4 tables and the last one might have less.


The template looks like this

Note the Excel's Page Break between the rows 9 and 10.

To achieve this, a Conditional Element, 3 Local Variables and Preparation Actions in the Table to be displayed are used. The local variables' definitions are below


The number of TablesPerPage is kept in a variable to ease the maintenance of the report. 
​
TablesPerPage=4

The Counter will be increase by 1 after each repetition.
​
Counter=1

The total number of repetitions is required as Mail and Deploy internally uses the first repetition as a sample for the rest of them, therefore it contains the last number. A Debug version of the report is document here to comprehend this behavior.
​
TotalRepetitions = [Datasource].[Executive Dashboard].[Expression].[ count(distinct "Product Group Desc") ]

The Counter is increased by 1 in the preparation actions of the table that is displayed.


The Condition Element has the following Condition


If ([LocalVariable].[Counter]=1+[LocalVariable].[TotalRepetitions], 
1 MOD [LocalVariable].[TablesPerPage] =0,  
[LocalVariable].[Counter] MOD [LocalVariable].[TablesPerPage] = 0  )


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.