CR XI - combine data from 2 databases

[ZaneL]

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?

 

[lbass]

Go to database->database expert->and select "Add command". You can write the union statement there.

-LB

 

[Madawc]

Another method is to have a subreport: the subreport can access a different database, though to do this at detail-line level would be very inefficient.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Turkbear]

Hi,
An even better method ( in most cases) would be to create a view in one of the instances that does the UNION ( using a database link) ..That way, the report only needs to connect to one instance...





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[ZaneL]

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 reports it is good solution, but not for all. If I will not find other better solution, I will to use subreports.

Turkbear : Databases? Ok. …it is a good idea. I will try it. I tried to create the two similar universes with the different connections and then linked them. At first moment everything looked good, but then I fond that the data in the tables are not different anymore. ? The linked universes connection was changed.