Kbase P93241: Report Builder: How to join two tables that have no direct relation?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/21/2005 |
|
Status: Unverified
GOAL:
How to join two tables that have no direct relation with Report Builder?
GOAL:
Can non related tables be joined with Report Builder?
FIX:
You can use a calculated field to Join the tables. For example:
1. Create a calculated field where the expression evaluates to the join criteria.
2. Create a join to the second table. For the field pairs, the "From Table:" should be the calculated field and the "To Table:" will be the field that it relates to in the second table.