Progress
Results User’s Guide
for UNIX


Defining Files and Fields

In this section you use the Define option to create a report that uses information from four different database files.

  1. Select Define.
  2. Results will prompt you to select files and fields. First you see a list of files that you can use for your report:

    NOTE: If the files are listed by description, press MODE (F9) to toggle to the file names.

    The files listed in this window are those available when you start Results against the mysports database. If you start it against another database, you see the files from that database that you have permission to view.

    The counter in the lower right-hand corner of the window tells you the total number of files in the list.

  3. Select the Customer file.
  4. The window displays mysports.Customer next to the Files label. Because there are other files joined (or related) to the customer file, a Select Related File window appears with a listing of those files:

  5. Select the Order file.
  6. The window displays customer and order in the list of files, and displays an additional window of files related to the order file:

  7. Select the Order-Line file.
  8. Another window appears displaying files related to the order-line files.

  9. Select the Item file.
  10. Press END.
  11. You will see a list of fields from which you can choose:

    This list shows, in alphabetical order, the fields you have permission to view from the selected files. You can include any of these fields in your report. Some fields, for example Cust-num, are listed twice because they are contained in more than one file. The file and database containing the field are listed in parentheses.

  12. Press MODE to toggle to the labels.
  13. The list of field labels appears in the window:

    These are the labels that appear in your report. Unlike field names, field labels can have blank spaces in them. The fields are listed in alphabetical order by field name now. If a field does not have a label, the field name appears as the label.

    Note that because you chose to show fields as field labels, the display is now field labels. The fields appear as labels until you toggle them back to field names.

  14. Select the following fields, in the order shown:
  15. Fields
    Database file
    Name
    Customer
    Order-num
    Order
    Line-num
    Order-line
    Item-Name
    Item
    Qty
    Order-line
    Price
    Order-line

    Results numbers the fields in the order in which you select them. They will appear in the same order in your report.

    If you select a field by mistake, highlight it again and press RETURN to deselect it. If you select a field out of order, highlight it and type the order number next to it. Results renumbers the other fields automatically.

  16. Press GO to lay out the fields in this report.
  17. The Report Layout window shows the report layout and displays the formats for each field.

    The information below the field names is the display format information. For example, x(20) means that the names in the name field can be 20 characters wide >>>>9 means that the Ord-num field is a number up to five digits long in a right justified format. When displaying records, Results replaces the > with a blank if there is no digit in that position. For example, if the customer number is 4, Results shows it as ‘ 4.’ (See "Field Display Formats," for more information about how fields are formatted for display.) These are default values that appear in the window. You can change the formats using the Settings option, but leave them for now.

    The Report Width marker in the lower-right corner of the Report Layout window tells you that this report is 76 characters wide. The maximum width for any report is 255 characters.


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