Settings for Reports

Administrators can configure settings that control the generation and formatting of reports.

Handling Rows that Span Multiple Lines

After the 23.05 monthly update, when generating reports in Microsoft Excel format, a row that spans multiple lines may result in empty rows displayed after the row that contains data. This may cause a problem if you have scripts that perform calculations on a row value. Account Reconciliation provides a setting to control the display of these extra rows.

To resolve this issue, you must modify the template file of the report by performing the following:

• Remove any empty lines from the table row

• Change the row height of the row to 0

Alternatively, Account Reconciliation provides a setting to control the display of these extra rows. This setting applies to all the reports.

Specifying Settings for Reports

1. From Home, click Application, then click Configuration, and then select the System Settings tab.

2. Select Reports.

3. Unselect Enable Row Split to ensure that multiple rows are not displayed for each row of data in Microsoft Excel.

4. In Excel Export Format, select the Excel format to be used when export Account Reconciliation data. Options are:
   • Excel 97 – 2003 (.xls): Creates files in the .xls format.
   • Excel (.xlsx): Creates files in the .xlsx format.