Release 10.1A: OpenEdge Reporting:
Query/Results for UNIX

> ## Exporting reports in Progress format

> This section describes how to export data in Progress export format. By default, Results puts export data in Progress format. Figure 7–2 shows an example of records in the Progress export format.

> Figure 7–2: Sample of Progress export format

> This format consists of one record per line, with the beginning and end of each character field denoted by double quotes ") and a space separating each field.

> You can select the export type you want before or after you select the fields for the report. You can select fields using the Define option, or you can transfer them from the Reports module using the Module option. In this example, you select the fields in the Data Export module.

> 1. Define the report you want to export.

> For example, select the files, then the fields you want to export. Then define any order criteria and calculated fields that you want to include. Also, define `WHERE` clause criteria if you want a subset of records. (For information on selecting files and fields, defining order and `WHERE` criteria, or defining calculated fields, see Chapter 3, " A Tour Through Results.")

> 2. Press GO to insert the fields in the layout.

> The files and the file relation information appear in the Data Export Info window, and the fields appear in the Data Export Layout window.

> 3. This window also shows all of the fields you selected in the order you selected them. Notice that the fields are prefixed by the name of the database and file they come from. The default export type, Progress, appears in the Export Type field:

> The Layout window also shows the export settings. It shows that each record ends with a carriage return and a line feed. It also shows that character fields are surrounded by double quotes and separated by single spaces.

> 4. Run the data export report by selecting the Run option, and then select any output device.

> Your report appears in the Progress export format.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095