Export Report Data

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:

How to Export Report Data

To export report data

  1. On an open report window, select the Export Report menu option. The Export Current Data page opens.

  2. From the selection box, select the format for the data.

  3. Click the Export Data button.

  4. 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.

Formats for Exported 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

See Also

Create a new report

Run a report from a saved report definition