Template information allows you to choose an Excel Template for the report to run into. The Excel file can be either a template or a standard spreadsheet file. You have the following options:
|
Template |
Description |
|
Use Active Sheet |
This will run the report into the sheet that was active the last time the template was saved |
|
Sheet Name |
Allows you to choose the Sheet to run the report into |
|
Clear Sheet |
Deletes all data on the sheet before the report is output, however does not remove formatting |
|
Append to Sheet |
Appends the report to the end of the worksheet file. This is used if you want to run one report after another, on a similar entity |
|
No Report Headings |
If the Append to Sheet box is checked, you can choose not to output report headings, so the data will appear under the existing data without headings |
|
No Period Headings |
If the Append to Sheet box is checked, you can choose not to output period headings |
3. To choose a different Excel template, click on the Template button, and browse to the location of your preferred file.