Kbase P108760: How to combine left-outer join with filter in right table in Report Builder ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
How to combine left-outer join with filter in right table in Report Builder ?
FACT(s) (Environment):
Progress 8.x
Progress 9.x
FIX:
1. Define a left Outer Join between the tables.
2. Create a filter on the related tables field which is part of the join field pair.
<right-table-field-name> = ?
Append a filter with OR criteria, specifying the filter that you want for your right table.
As result, you will get OR the records from left table without matching records in the right table, OR records matching the filter for the right table.