Once you have created a custom template file, you may use it to format your VTS reports. The instructions below will help to guide you through this process.
Note: As discussed in Using a Microsoft Excel Template File to Generate Reports, the use of Microsoft Excel template files is only available to those users who have Microsoft Excel installed on their PC, and who are using the Screen Display report output option.
1. Navigate to the Reports page.
2. Set the report parameters as you require (i.e. select the report type, the tags whose data you wish to be included in the report, and configure a time period for the report). If you require assistance in setting up a report, please refer to the information on generating reports can be found in Generating a Report.
3. Select Screen Display in the Output Types drop-down list on the Reports page.
4. Select the Use Excel to Display Screen Reports checkbox. The Template field above this checkbox becomes enabled.
5. Click the Browse button. The Template File dialog opens and allows you to browse your hard drive for your template file.
6. Browse to your application directory and select your custom template file.
7. Click the Open button. The Template File dialog closes and you are returned to the Reports page where the path to your custom template file is displayed in the Template field.
8. Click the Run Report button.
The report will be executed and will be formatted according to the configuration of your custom template file.
Note: A report who’s Output Type has been configured as Screen Display, and for which the Use Excel to display screen reports checkbox has been selected will open as a regular screen display over VIC connections.