Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sql join cross databases/platform?

Status
Not open for further replies.
ywg99

ywg99

Programmer
Joined
Apr 26, 2005
Messages
5
Location
US
Can Crystal Reports v10 or v11 join the data records from different databases (MS SQL Server/Informix on Windows, MS SQL Server on Windows/Informix on Linux)? Does Crystal Reports provide all the ODBC drivers? Thanks.
 
Sort by date Sort by votes
I'm able to do it with SQL Server and Oracle with my CR XI. I just use the native drivers.

-lw
 
Upvote 0 Downvote
However, I might add that an ID in one database may not be the same in another. For example, the name_id value in MySql Server is different then the name_id assigned in my Oracle DB. So I had to find other ways of linking the name, like matching last name, firstname and DOB from both databases. Not the most accurate but close enough for what I am reporting.

-lw
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Gary Hnat
  • Locked
  • Question Question
Crystal SQL Code linking to partial database field entries
Replies
2
Views
1K
Gary Hnat
Gary Hnat
dgillz
  • Locked
  • Question Question
Cannot connect to any ODBC datasource with MS SQL Server data in crystal
Replies
8
Views
2K
LyleU
LyleU
PeaEssEl
  • Locked
  • Question Question
ASP.Net Crystal Reports connection to SQL Server through published website
Replies
2
Views
412
PeaEssEl
PeaEssEl
djieon
  • Locked
  • Question Question
Join two fields and one time
Replies
2
Views
321
hilfy
hilfy
blueboyz
  • Locked
  • Question Question
Join two Databases
Replies
2
Views
252
blueboyz
blueboyz

Part and Inventory Search

Sponsor

Back
Top