Multiple ODBC data-sources in a Crystal Report?

[Guest_imported]

Hi all,
I have a problem in which I have two data-sources on different servers and want to be able to query them simultaneously through a report to bring back results from each database. Is this possible and if so, how do I go about this?
Does this involve the use of Dictionaries or can I just add the tables within the report?
Note: The tables have the same field names but contain different data.
For Example, I would like to create a report to say, bring back all the names from the names-field in the two data-sources between two dates entered as parameters in the report.
Any response would be hugely appreciated,
Thanks!

Jonathan Barr

 

[teddyboy]

Not a problem. It's slow, but can be made to work. You must have a table from each db with an indexed field that will link across the 2 db's. Eg db1.tb1.Name_ID >>>db2.tbx.Name_ID. They must also be the same data types.

 

[Guest_imported]

Ok Thank-you!