How to use page breaks in Excel when using a repeater (same sheet)? (2/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, this time the Debug version of the report.

The definitions are the same as the example in How to use page breaks in Excel when using a repeater (same sheet)? (1/2)

The output should look like this:

Note the green number on the first page. The first table has the Counter number 12, which is the number TotalRepetitions + 1, that is the reason the Condition element has an extra if statement.

The template looks like this

Note the Excel's Page Break between the rows 12 and 13.

The extra Expression elements are the following

%%Counter%% = [LocalVariable].[Counter]

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

%%TotalRepetitions%% = [LocalVariable].[TotalRepetitions]

%%TablesPerPage%% = [LocalVariable].[TablesPerPage]

And the cell C9 contains the following formula

="Counter MOD "&$B$3

as we know that Mail & Deploy only accepts one tag per cell, the screenshot above might look confusing.

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.

• Related Articles

• 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 ...

• How to Apply a Repeater to Multiple Pages in Mail & Deploy?

  You want to apply a repeater to more than one page in Mail & Deploy so that the pages are sorted by the value of the repeater. For example: Repeater value 1 - Page 1 Repeater value 1 - Page 2 Repeater value 2 - Page 1 Repeater value 2 - Page 2 ... ...

• Creating Custom Calculations in Excel Reports Using Mail & Deploy?

  You want to create an Excel report using Mail & Deploy. Specifically, you have a table spanning columns A to K and need Column G to display the result of Column I × Column B, instead of using the result directly from the Qlik app. Solution: While the ...

• How to create an Excel report using Snowflake as a data source in Mail & Deploy (with example)?

  FIRST CREATED ON 5 Mar 2024 I AUTHOR Emma Camacho Creating an Excel report using Snowflake as a data source in Mail & Deploy allows you to leverage powerful data analysis capabilities. Here's an example to help you get started: Use case: Display ...

• How to show/hide sheets in Microsoft Excel reports conditionally?

  FIRST CREATED ON 19 Dec 2024 I AUTHOR Emma Camacho It is possible to show/hide sheets in Microsoft Excel reports using the Condition property of Elements together with the Exception Behavior. Follow the example to hide Sheets if the CY Sales = 0 and ...