I have three tables. The main table and two supporting tables. I need to outer join both of the supporting tables, but crystal will only allow me to outer join one of them at a time without a dll error. Each supporting table has one unique field that matches to the main table.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Multiple Tables 1
- Thread starter tljleljl
- Start date
-
1
- #2
Create a VIEW (Query in MS Access) that does an outer join to the first table. You can then use that VIEW as a table in Crystal and do an outer join to the second table.
Alternatively, do the whole joining business using VIEWs
on the back-end database.
Subreports are also an option, but the VIEW approach is simpler and faster...
Cheers,
- Ido ixm7@psu.edu
Alternatively, do the whole joining business using VIEWs
on the back-end database.
Subreports are also an option, but the VIEW approach is simpler and faster...
Cheers,
- Ido ixm7@psu.edu
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question