Split tables in reports
You can split tables in your report definition, for example, to distribute rows with comprehensive contents to multiple tables.
For each row of the table, a new table is created, and the new tables are displayed horizontally in the published report.
You cannot split crosstabs.
In MS Excel, a new worksheet is created for each table. The maximum number of worksheets is 1370.
Prerequisite
You have the Report management function privilege.
Procedure. Procedure
Click PPM > Configuration.
Click Report definitions in the Configuration bar.
Right-click in a table and select Table properties.
Enable the option Split each table row into a new table.
Click OK.
The changed settings are transferred to your report definition.