Getting a Total Summary from 2 Databases

[davidmo]

I have 2 ACT databases that I need to get a combined total summary per customer.

One database has all items and their amounts that have been resolved for 2004.

The second database has all items that are still open for 2004.

I need to get a total number of items/$$ by customer for the entire 2004.

The databases are mirror images of each as far as fields and formats.

What is the best way? Sub-report?

 

[synapsevampire]

Depends on your version of Crystal, and what privileges you have on the database.

You're better off to create the data source on the database side using a View or Storeed Procedure, but you can use a subreport for one of the databases that's linked by the customer.

-k

 

[IdoMillet]

Here's one option:

Use a MS Access database to link to the two databases.

Create a query in Access that looks like:
---------------------------
Select * From Linked_Table1
UNION ALL
Select * From Linked_Table2
---------------------------

Create a Crystal Query that uses the MS Access database
as the data source and the Query as a "table".

Voila.

The same UNION approach can be used in a CR 9 Command or a CR 8.5 SQL Query.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com