Multiple database joins
-
- Posts: 2
- Joined: Tue Oct 10, 2017 12:44 pm
Multiple database joins
In R&R for windows, SQL Edition, version 9.0, Is there a way to make/run a single report that uses both data on DB2 and oracle database?__Some data are spread across the two different databases. I have the ODBC drivers on both database and I can create report using one datasource connection.____If the designer can not do this task, what product do you have that will make this task possible?____Thanks____
=> RE: Multiple database joins
What you would need to do is create two reports, one against each data source. Then export each report to DBF. You can then use the Xbase version of R&R to combine both exported DBF files into a single report.____Kathleen__R&R Support