I have a table with a detailed group with PageBreak set to 'After' and a crosstab inside the table with a row group that also has PageBreak set to 'After'. The pagination is respected in the preview of the designer, however, when exported to XLSX, there is only one worksheet generated.
If I remove only the PageBreak of the detailed table group, there is no pagination and the generated worksheet is only one.
If I remove only the PageBreak of the crosstab row group, there is pagination and the generated worksheet is correct in number. However, the content is not split as expected among the sheets.
If I make the detail table group static and remove its PageBreak, the pagination and the worksheets of the Excel document are as expected.