Crystal XI and 2 databases

[kskid]

Crystal Developer XI
Business Objects Enterprise XI
2 Oracle Databases
Native Oracle ODBC Connection

As you can see I have to create a report that will access data from not just one Oracle Database but 2.

We are in the process of installing a new version of some vendor software. With the new version is also a change in the database design. As far as the data is concern, only active records (Cases) will be transferred from Database A to database B. Any new cases that are entered into database B using the new application. Database A will still be available for use for query purposes as well as reopening old inactive cases. These cases must remain in Database A along with any activities that may occur.

All of my current reports work well with just one database. I was able to verify the report against the new database easy enough.

How can I change all of my current reports to now look for activity in the old and new databases and without the duplicates, too. So my ONE report should provide all the data I need regardless of where it resides. For a given name, there may be cases in the

old database only or
new database only or
both databases but without the duplicates from the old.

Is the Add command using UNION the only way to go? That could be very cumbersome, especially when designing new reports.

Can Imerge two databases into one using Business View Manager? Does it come with BOXI Enterprise? If so, where is it? I can't see it anywhere on the CMC or main menu.

Is there a way I can accomplish the above with a series of subreports with shared variables to tell me where the records reside and eliminate the duplicates? It may be slower processing but a lot easier to maintain, I think.

 

[Turkbear]

Hi,
The best ( and maybe the only practical) way to do this is with views created in one of the database instances that selects records from the similarly named table in the other one (using a database link) and UNIONing it with the one on the local instance
( it would be a better implementation of your app if they were on 2 schemas in the same database instance, but, what you have is what you have..)




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