Multitple DataSource Connection

[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______

[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