When you select Screen Display in the Output Type drop-down list, VTS provides you with the option to display the report in a simple window that opens on your screen, or in a Microsoft Excel spreadsheet. The Use Excel to display screen reports checkbox enables you to choose between these two options.
• If the Use Excel to display screen reports checkbox is not selected, your report will open in a simple window.
• If the Use Excel to display screen reports checkbox is selected, your report will open in a Microsoft Excel spreadsheet.
Note: In addition to the above options, you may further specify a Microsoft Excel template file to use to change the appearance of your report. Please refer to Using a Microsoft Excel Template File to Generate Reports for instructions.
Regardless as to whether the Use Excel to display report checkbox is selected, you need not enter a path for the report, as it is opened on the screen, rather than saved to disk, however, if the generated report is displayed in a Microsoft Excel spreadsheet, you can save the file to disk from within Microsoft Excel for later retrieval and review.
Generate a Screen Report in a Simple Window
To generate a screen report in a simple window:
1. Configure the report type, the tags whose data you wish included in the report, and the duration for the report. (If you need assistance in completing these tasks, please refer to Generating a Report.)
2. Select Screen Report from the Output Type drop-down list.
3. Ensure the Use Excel to display report checkbox is not selected.
4. Click the Run Report button.
Generate a Screen Report in an Excel Spreadsheet
Note: A report that has its Output Type 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.
To generate a screen report in a Microsoft Excel spreadsheet:
1. Configure the report type, the tags whose data you wish included in the report, and the duration for the report. (If you need assistance in completing these tasks, please refer to Generating a Report.)
2. Select Screen Report from the Output Type drop-down list.
3. Ensure the Use Excel to display report checkbox is selected.
4. Click the Run Report button.
Note: Complete step-by-step instructions on generating a screen report using a Microsoft Excel template file can be found in Using a Microsoft Excel Template File to Generate Reports.