Run a Report

Before creating an Excel spreadsheet report for a query, the Excel report template used to generate the report must be selected. This procedure need only be carried out once for each query, or when the template linked to an query needs to be changed.

Right-click on the query and select the Set Excel Report Template option from the menu that is then displayed. The Set Excel Report dialog is then displayed:

The dialog lists each Excel report template that was set up for the query using the Excel Reports tab of the Options dialog.To select the required Excel report template, check the Select checkbox.

Click OK to close the dialog.

To generate the report, right-click on the query results grid and select the View Excel Report option from the menu that is then displayed.

The View Excel Report dialog is then opened, with the generated report displayed:

If there have been any changes to the data on the report since the report was last saved to Excel or printed, the cells containing the changed data may be displayed in the background colour specified on Fonts and Colours tab of the Options dialog. Whether or not Excel report change highlighting is used is specified on the Options tab of the Options dialog.

To save the report as an Excel spreadsheet, click Save To Excel. A standard Save As dialog is then displayed.

To print the report, click Print Excel Report.