Report Options Dialog: Custom Excel Tab

CustomXLReportOptionsPP.jpg

This property page is part of the Report Options Dialog which appears when you select Reports } Options from the main menu of the application.

From this Dialog you can customize your own report to suit your needs by choosing what to include in the final Excel Report.

General Options

You can either use the Default options or Custom options. To customize the general options click on the ‘Customize…’ button to bring up the Report Options Dialog: General (Default) Tab interface. Options such as the Export Format and the Page Breaks do not apply to this report as the export format is always Excel (.xls) and there are no page breaks in this report. The changes made in general options through this interface will be applied in various sections only on the Custom Excel report.

Add Chapters to Existing File

It is possible to add the created chapters of a custom Excel report as worksheets to an existing workbook. This is helpful when users may have included in the Excel file, other sheets, tables, charts or their own custom programming scripts for manipulating the data in the report. Checking the option ‘Add Chapters to Existing File’ and specifying an Excel file (cilick on BrowserBtn.jpg)will keep the workbook intact and add the created chapters or replace them if the chapters with the same name already exist in the workbook.

Content

A tree with a list of the sections and subsections that can be included in this report is displayed on the left hand side. Certain subsections may have more detailed options which can be edited on the right hand side of the dialog. Select whether they are to be included by clicking on the respective include checkbox.

For more information on what is available in the tree you may also see Custom Excel Report.