Handling page breaks
By default, XFRX does not break pages in the XLS output the same way as in other output formats – it is run in the plain mode instead, which means the output is one sheet - as long as it needs to be, with a page header on the top and a page footer at the bottom.
If more reports are processed, each report creates one sheet in the output document.
There are two options you can use to modify the way the page breaks are handled:
Generating sheet per page
To enable this option, call SetOtherParams method to set the “SHEET_PER_PAGE” parameter to .T.:
This will switch off the “plain” mode and the page breaks will correspond to other output options. Each page will be generated as a new sheet in the Excel document.
Please see more information about the SetOtherParams method in Methods common in XFRXListener and XFRXSession classes reference
Generating sheet per start-each-group-on-a-new-page groups
To enable this option, call SetOtherParams method to set the “SHEET_PER_NP_GROUP” parameter to .T.:
This option combines the plain mode and the sheet-per-page mode. The report runs in the plain mode but a new sheet is generated for each report group with “Start each group on a new page” flag set to .T.
Add page break in sheet
This options add page breaks in sheet by pages in report for XFRX#INIT + TransformReport() and XFRX#LISTENER (since XFRX 15.7).