Depending on the report displayed, you can export data from newly created or saved reports to be used in other applications such as spreadsheet or word processing programs.
This topic explains the following:
To export report data
On an open report window, select the Export Report menu option. The Export Current Data page opens.
From the selection box, select the format for the data.
Click the Export Data button.
In the Download File dialog box, click Save or Open. If you select Open, the data is opened in the application on your computer that is configured to display the data format that you selected. If you select Save, you are prompted for a file name and directory to store the saved the data.
The following table describes the formats in which you can export data.
Format |
Description |
File Extension |
CSV |
Comma-separated values. |
.csv |
dBASE2
|
dBASE-II format. Files exported in this format can be opened in Microsoft Excel. |
.dbf |
dBASE3
|
dBASE-III format. Files exported in this format can be opened in Microsoft Excel. |
.dbf |
DIF |
Data Interchange Format. Files exported in this format can be opened in Microsoft Excel |
.dif |
EXCEL |
Microsoft Excel format. Files exported in this format can be opened in Microsoft Excel. |
.xls |
EXCEL5 |
Microsoft Excel5 format. Files exported in this format can be opened in Microsoft Excel. |
.xls |
HTML TABLE |
HTML table format with <table>, <tr>, and <td> elements. Files exported in this format can be opened in a text or HTML editor. |
.html |
PSREPORT |
Powersoft Report format. |
.psr |
SQLINSERT |
SQL syntax. This saves a SQL CREATE TABLE statement for the table and an INSERT INTO statement for each row. The statements are saved into a text file. The simple file name is used as the table name in the SQL statements. |
.sql |
SYLK |
Microsoft Multiplan format. Files exported in this format can be opened in Microsoft Excel. |
.xls |
TEXT |
Tab-separated columns with a return at the end of each row. Files exported in this format can be opened in a text editor. |
.txt |
WKS |
Lotus 1-2-3 format. Files exported in this format can be opened in Lotus. |
.wks |
WK1 |
Lotus 1-2-3 format. Files exported in this format can be opened in Lotus. |
.wk1 |
WMF |
Windows Metafile format. Files exported in this format can be inserted into Microsoft Word documents as graphics. |
.wmf |