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!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
CR XI - combine data from 2 databases
LB: But there is a one big problem. As I understand it is not possible to write UNION statement for 2 databases (with different instances … in fact two different servers) using "Add command”. I tried already: ? Do you know how to write UNION statement in that case? Madawc: For some...- ZaneL
- Post #5
- Forum: Business Objects: Crystal Reports 2 Data Access
-
CR XI - combine data from 2 databases
Is it possible to combine data from 2 Oracle 9i databases (with identical tables and fields, but with different data) into one report? I use CR XI. I would like to use UNION, but I cannot edit SQL ("Show SQL Query"). Any suggestion?- ZaneL
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 2 Data Access
