[en] Varicent Incentive Compensation Management Documentation

[en] TS002110686 — Section breaks are not present when publishing a data grid to Microsoft Excel

[en] Fixed: Resolved an issue where, when publishing a data grid that contains sections breaks to a Microsoft Excel file, values after the section break are missing.

[en] Reproduction Steps

[en] 1. From Composer, add a table.

[en] Note: the table should contain two columns.

[en] 2. Add a Presenter report.

[en] 3. Edit the Presenter report.

[en] 4. Add a data grid to the Presenter report, using the table from step 1 as a source.

[en] 5. Select the cell.

[en] 6. From the palette, under Data Grid, click the Sort Selection icon.

[en] 7. From the list of available sources, drag the first column into the Sort Order pane.

[en] 8. Click the Edit icon.

[en] 9. Check off the 'Add a Section Break' checkbox.

[en] 10. From the Source drop-down menu, apply 'Web User' to the first column and apply 'Current Date' to the second column.

[en] 11. Click 'Save.'

[en] 12. Set Portal Access for the report.

[en] 13. Log in to Payee Web.

[en] 14. Go to the report and observe the values after the section break.

[en] The result is the values following the section break are not displayed.