Formats of Report Output

There are several report output formats that can be used.

Webpage (HTML)

The report output will be displayed in a new Internet browser window as a web page.  Some reports may display multiple tables of data.  This format is best for quickly viewing transaction and system information.

Microsoft Excel (XLS)

The report output will be display in a new Internet browser as a Microsoft Excel spreadsheet.

NOTE:  There is a known issue with Microsoft Excel 2000 that prevents a downloaded Excel file from being saved to your hard drive.  This is usually due to the file being opened in your Internet browser.  You may also be prompted for a username and password.  If you have this version of Excel, it is suggested that you use the Comma delimited (CSV) format, as it ignores the Internet browser when opening the file and sends the file directly to Excel.

Comma delimited (CSV)

The report output will be formatted in a manner that divides the data using commas.  A File Download box will be displayed asking you to Open the report results in viewer (such as Microsoft Excel), or Save the results to a .csv file (which can be opened from your hard drive using Microsoft Excel).

TIP:  This is the best format if you wish to sort, filter, and edit the data for printing or distribution.

Raw text (TXT)

The report output will be formatted and output directly to a text file.  A File Download box will be displayed asking you to Open the report results in a text viewer, or Save the results to a text file.  This format is used for downloads of data that are to be loaded into older database systems.

XML

The report output is converted to XML format in a new Internet browser window.  This format is used for downloads of data that are to be loaded into newer database systems that are configured to interpret the XML output.

 

Related Topics