I can't display fields from two different sql server databases ????

[amasny]

Hello,
I have two MSSql server with one table in one database and one table with other database (two odbc sources). These tables has one column each, with data related to each other. My problem is that i can't display joined data on CR report. There is data displayed only from one odbc source.
I need help how to display those data or confirmation that displaying data from two sources is impossible.

 

[Madawc]

Which version of Crystal?

A subreport should be able to access the other database.

Madawc Williams
East Anglia, Great Britain

 

[amasny]

Version 8.5

 

[Turkbear]

Hi, even without a subreport you should be able to add tables from multiple data sources ( Under Database..Add Table)-
do the tables have a common field for linking ( with only 1 column each, I do not see how they can be related to each other).