Page 1 of 1

Multitple DataSource Connection

Posted: Thu Mar 07, 2002 8:38 pm
by Bert_(Guest)
I am running Arpeggio for Desktop Report Designer 2.0 SQL version 9.0.9.____I am joining two tables with two different ODBC drivers. __One is Oracle ODBC driver and the other is Microsoft dbf driver. If I go to File/Data Source Connection, I can see both Oracle and the dbf connection sources. However, when I try to create a join between the two tables, I can not see both tables together. I have no problem with creating reports using either the two sources individually. ____Is there any document to show how to create reports using multiple data sources?____Thanks____Bert______

=> Multitple DataSource Connection

Posted: Fri Mar 08, 2002 11:45 am
by kfleming
You cannot join tables from datasources that use different ODBC drivers. You would need to export data from the Oracle report to a DBF file so that you could then use a DBF datasource to combine it with your other DBF data.____Kathleen__R&R Support