Progress
Results User’s Guide
for UNIX
Selecting a Data Export Type
- Select Module on the Reports menu.
The Reports Info window appears:
![]()
The list displays all the modules you can transfer out to from the Reports module.This list is different when you select the Module option from other modules. For example, if you select the Module option when you are in the Query module, the list includes Reports and the other available modules.
- Select Data Export.
Results brings up the Data Export module:
![]()
Notice that some of the information you defined in the Report module was automatically transferred to this module. For example, the files you selected, the WHERE clause, and the order criteria you defined in the Reports module are now in this module. Some of the information from the Reports module didn’t transfer over (for example, field names, hidden repeating values, and totals and subtotals do not appear).
You can define a data export report based on the file relation information you just transferred. In addition, you can expand or delete the default information.
For example, you can use the submenu options of the Define option to add fields, counters, and calculated fields just as you did in the Reports module. In fact, when you select the Define option in the Data Export module, you see all the submenu options that you see when you select it in the Reports module, except the Totals and Subtotals option. Instead of that option, you see the Width/Format of Fields option. (For more information about the Width/Format of Fields option, see Data Export Module."
In this exercise, you will change the settings to put this report in the format for Microsoft Word.
- Select the Settings option.
These options appear:
![]()
This list shows all the export formats you can select. (The last item on this list is a default option that appears when you run Results against a copy of the sports database. By default, its name is in the language used for the initial build. Your database administrator can change its name or functionality through the Administration module.)
- Select Microsoft Word.
The following settings appear in the Data Export Layout window:
![]()
This window shows the default Microsoft Word settings. For example, it shows the characters that denote the end of a record. In this case, the default is cr lf (carriage return line feed). It also shows that the fields are surrounded by double quotes and separated by commas.
- Run this definition on your terminal.
The data appears in Microsoft Word export format:
![]()
This listing is different than if you ran it in Progress format. In this format, a comma separates the fields in each record. In Progress format, a space separates each field and the line of headers does not appear at the top of the report.
- Press END to return the Data Export screen.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |