Progress
Report Builder
Tutorial
Defining Joins
To access all of the fields needed to calculate the report values, you must define joins to the Order, Order–Line, and Item tables.
Follow these steps to define the joins:
- Define a join from Salesrep to Order on the Sales–Rep field. You must define this join to access the Order–num field, which is the connecting field for the next join.
- Define a join from Order to Order–Line on the Order–num field. The Order–Line table contains the Extended–Price field, which you will use to calculate report values. This table also contains the Item–num field, which you must use for the next join.
- Define a join from Order–Line to Item on the Item–num field. The Item table contains the Item–Name field, which you use on the report layout.
When you finish defining all three joins the Joins dialog box should look like this:
![]()
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |