Kbase P25536: How to make joins in Report Builder?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/28/2005 |
|
Status: Verified
GOAL:
How to make joins in Report Builder?
GOAL:
How to add a join to a Report Builder report?
FIX:
The following example details the standard way to add a join to a report in Report Builder. For additional information about joins in Report Builder, please refer to chapter 8 "Joins" of the Report Builder User's Guide.
1) Start Report Builder and connect to a database
2) Add a table and fields to the report
3) Select Database > Joins
4) In the New Join dialog box that appears, select the related table to join to in the Join To Table drop-down list
5) Choose the New Field Pair button to display the New Join Field Pair dialog box
6) Select the controlling table from which the join should be made from the From Table drop-down list
7) Select the join field from the controlling table from the From Field selection list
8) Select the join field from the related table from the To Field selection list
9) Choose OK to return to the New Join dialog box
10) Select the Join Type
11) Choose OK to return to the Join dialog box
12) Choose Close to return to the report layout