Episode 2: Excel Function: RW.Tools.PageBreak aka RWPageBreak
Quote from Karen Hewitt on June 17, 2026, 8:13 amEpisode 2 is here! If you caught Episode 1 on RW.Tools.Suppress, this one picks up right where it left off.
RW.Tools.Suppress controls what shows up. RW.Tools.PageBreak controls where it lands.
RW.Tools.PageBreak lets you insert horizontal or vertical page breaks dynamically at report generation time, based on a condition you define in your template. No more hardcoded breaks that break down when row counts vary by recipient. This is especially useful when bursting to multiple cost centers or departments, or when working with IBM Planning Analytics Dynamic/Active Forms that expand and collapse based on data.
Quick heads up on naming: RWPageBreak changes to RW.Tools.PageBreak in the next official release (v5.0.0.91), but RWPageBreak will still function as expected — no need to convert your existing templates to the new name. We've attached two Excel files for a more detailed walkthrough of the formula in action.
Two files attached: RW.Tools.PageBreak_Examples — for v5.0.0.91 or later RWPageBreak_Examples — for current versions
You can create a simple job in Reportworq and use the file as your report source to see the formula work in a real job run. Just select Excel in the distribution screen and run the test — no other modification to the job is needed.
Let us know what you think and if you have any questions!
Episode 2 is here! If you caught Episode 1 on RW.Tools.Suppress, this one picks up right where it left off.
RW.Tools.Suppress controls what shows up. RW.Tools.PageBreak controls where it lands.
RW.Tools.PageBreak lets you insert horizontal or vertical page breaks dynamically at report generation time, based on a condition you define in your template. No more hardcoded breaks that break down when row counts vary by recipient. This is especially useful when bursting to multiple cost centers or departments, or when working with IBM Planning Analytics Dynamic/Active Forms that expand and collapse based on data.
Quick heads up on naming: RWPageBreak changes to RW.Tools.PageBreak in the next official release (v5.0.0.91), but RWPageBreak will still function as expected — no need to convert your existing templates to the new name. We've attached two Excel files for a more detailed walkthrough of the formula in action.
Two files attached: RW.Tools.PageBreak_Examples — for v5.0.0.91 or later RWPageBreak_Examples — for current versions
You can create a simple job in Reportworq and use the file as your report source to see the formula work in a real job run. Just select Excel in the distribution screen and run the test — no other modification to the job is needed.
Let us know what you think and if you have any questions!
Uploaded files:- You need to login to have access to uploads.
Quote from Llewellyn Evans on June 17, 2026, 11:18 amThis was incredibly helpful and immediately sparked a use case for one of our current dynamic reports.
We have a dynamic TM1 PAfE report where elements populate as rows, and the report can grow from around 5 rows to 200+ rows depending on the report settings. At the bottom of the report, we include visual charts. Previously, depending on where the page break occurred, the PDF output could split the charts across two pages.
Using
RWPageBreak/RW.Tools.PageBreak, we were able to dynamically push the chart section to the next page only when needed. For example:=RWPageBreak(AND(ROW()>58,B230=""),TRUE,FALSE)
This keeps the visuals together and prevents the PDF from cutting the chart section in half.
Thanks for publishing the video and sample files this solved a real reporting issue for us.
This was incredibly helpful and immediately sparked a use case for one of our current dynamic reports.
We have a dynamic TM1 PAfE report where elements populate as rows, and the report can grow from around 5 rows to 200+ rows depending on the report settings. At the bottom of the report, we include visual charts. Previously, depending on where the page break occurred, the PDF output could split the charts across two pages.
Using RWPageBreak / RW.Tools.PageBreak, we were able to dynamically push the chart section to the next page only when needed. For example:
=RWPageBreak(AND(ROW()>58,B230=""),TRUE,FALSE)
This keeps the visuals together and prevents the PDF from cutting the chart section in half.
Thanks for publishing the video and sample files this solved a real reporting issue for us.
Uploaded files:- You need to login to have access to uploads.