Two tables from different ODBC Source- NO LINKING!

[hortensiam]

Hi!
I've two tables from differentes ODBC source. When I join them in Crystal, I can not access to view the SQL Query String and the data not appear.
Why?
Please help,
Thanks

 

[icytrue]

no sql query will be created if two different database drivers are used

Icytrue

icytrue@hotmail.com

 

[hortensiam]

Ok, but... why do not link well?. The fields must have equals names? or equals type?

 

[Turkbear]

Hi,
To link properly, both fields must be the same type and have the same values...

When you link the tables ( in the Visual Linking window)
do you get any warnings?..Does the report run in Designer?

 

[hortensiam]

Thanks,
It was a conceptual error with the linked tables

 

[synapsevampire]

Depending upon the tools available, consider using MS Access to link to the different databases/tables, then create a MS Access query (which allows for multiple join types) to expose to Crystal as the data source.

-k