Progress
Report Builder
Tutorial


Defining the Joins

For this report, you need to access data in the Order and Order–Line tables. Because Order is the master table, you only have to join to the Order–Line table.

Follow these steps to define the join:

  1. Choose Database Joins. Because this is the first join for this report, the New Join dialog box appears:
  2. Select the Order–Line table from the Join To Table drop-down list by double-clicking on it. Order–Line becomes the related table.
  3. Choose the New Field Pair button. The New Join Field Pair dialog box appears:
  4. Select Order–num as the join field from both tables, then choose OK. Report Builder returns you to the New Join dialog box. The join fields you specified appear in the Join Fields list.
  5. Choose OK. The Joins dialog box appears.
  6. Choose Close to return to the report layout.

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