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 gkittelson 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
Apr 26, 2005
5
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
Crystal SQL Code linking to partial database field entries
Replies
2
Views
609
Gary Hnat
Gary Hnat
dgillz
  • Locked
  • Question
Cannot connect to any ODBC datasource with MS SQL Server data in crystal
Replies
8
Views
986
LyleU
LyleU
PeaEssEl
  • Locked
  • Question
ASP.Net Crystal Reports connection to SQL Server through published website
Replies
2
Views
146
PeaEssEl
PeaEssEl
djieon
  • Locked
  • Question
Join two fields and one time
Replies
2
Views
125
hilfy
hilfy
blueboyz
  • Locked
  • Question
Join two Databases
Replies
2
Views
102
blueboyz
blueboyz

Part and Inventory Search

Sponsor

Back
Top