I have a table with grouping and GroupPageBreak set to After for the group.
In the detail cell of the table, I have a Panel with a Crosstab in it. The Crosstab has row groups, however, their properties are the default, hence, they don't force any Page Breaks.
When the report is previewed or exported to PDF, each table group is on its own page as expected.
I have set SplitWorksheetOnPageBreak to True for Excel rendering, so that each soft page, i.e. Crosstab in the table group is in a new worksheet.
This works fine, except that the first table group is split into two worksheets.