Report Tag Type Properties: Destination Tab
The Destination tab of the report tag type properties folder enables you to configure an output format and destination for the report to be generated by this tag.
(Click title to expand text)
The Output Type drop-down list enables you to select the format to be used to display this report. This can be one of:
• Default Printer: Prints the report to the printer configured for your PC under the Windows operating system.
• Printer: Enables you to specify the path to a printer other than the default printer configured for your PC under the Windows operating system.
• Text File: Generates the report as a plain, unformatted text file with the extension .TXT. This option enables the transmission of report data in the body of an e-mail message (please see "E-mail Report" below).
• Screen Display: Generates the report in a window on your screen. This format enables the use of a Microsoft Excel template file to modify the way your report appears. Please refer to Using a Microsoft Excel Template File to Generate Reports.
Note: A report that has had 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. The ‘Screen Display Using Microsoft Excel’ feature is not available for VIC connections at the present time.
• CSV File: Generates the report as a comma-separated value file with the extension .CSV. Such files are easily imported by a variety of different database software packages. This report output option enables the transmission of report data as an attachment to an e-mail message (please see "E-mail Report As Attachment" below).
• Formatted Excel XLS File: Generates the report as a formatted Microsoft Excel spreadsheet with the extension .XLS. (The report will feature a bold title and column headings.) This report output option enables the transmission of report data as an attachment to an e-mail message (please see "E-mail Report As Attachment" below).
• Plain Excel XLS File: Generates the report as a plain, unformatted Microsoft Excel spreadsheet with the extension .XLS. (Unlike the Formatted Excel XLS File option, the report will not feature a bold title and column headings.) This report output option enables the transmission of report data as an attachment to an e-mail message (please see "E-mail Report as Attachment" below).
• Access MDB File: Generates the report as a Microsoft Access database file with the extension .MDB. This report output option enables the transmission of report data as an attachment to an e-mail message (please see "E-mail Report As Attachment" below).
• ODBC Data Source: Enables you to specify an existing ODBC data source associated with an existing ODBC-compatible database file into which you wish the report data to be saved.
When selected, the E-mail Report checkbox causes the report generator to e-mail a copy of the report data to a specified address or set of addresses within the body of the e-mail message. The E-mail Report option is only available when you select Text File as your report output type. Instructions on transmitting report data in the body of an e-mail message can be found in E-mailing Reports.
When selected, the E-mail Report as Attachment checkbox causes the report generator to e-mail a copy of the report data to a specified address or set of addresses as an attachment to an e-mail message. The E-mail Report as Attachment option is only available when you select the Text File, CSV File, Formatted Excel XLS File, Plain Excel XLS File, or Access MDB File output option. Instructions on transmitting report data as an attachment to an e-mail message can be found in E-Mailing Reports ".
The E-Mail Settings button can be clicked to launch the E-Mail Settings dialog where the recipients, subject, and message for the e-mail can be configured. Instructions on transmitting report data via e-mail are provided in E-Mailing Reports ".
The destination field's label changes according to the selected report output type.
You may enter a path, printer, or ODBC data source for the report. (A path is not required for Default Printer or Screen Display output types). You may specify a path or printer using either the Browse button to navigate to the desired location, or by manually typing the path into the destination field.
The Browse button opens a dialog that allows you to explore your hard drive to locate a printer (when Printer is selected in the Output Type drop-down list) or path to a Microsoft Excel template to be used to generate this report (when Screen Display is selected in the Output Type drop-down list). Instructions on utilizing Microsoft Excel templates to generate reports can be found in Using a Microsoft Excel Template File to Generate Reports ".