Kbase P107565: How to display only the records from the Controlling table that do not have related records in the r
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/08/2005 |
|
Status: Unverified
GOAL:
Report Builder
GOAL:
How to filter for records that do not have a related record in the joined table
GOAL:
How to display only the records from the Controlling table that do not have related records in the related table
FACT(s) (Environment):
Progress 8.x
Progress 9.x
FIX:
1. Define a Left Outer Join between the tables.
This will return all of the records from the controlling table and any matching records in the related table. Report builder will use the ? as a value for the files in the related table when a matching record is not found.
2. Create a filter on the related tables field which is part of the join field pair.
field = ?
This will return only the records from the main table that do not have matching records in the related table.