Print Page | Close Window

Connecting two databases

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15684
Printed Date: 28 Apr 2024 at 6:42pm


Topic: Connecting two databases
Posted By: SheliaKWood
Subject: Connecting two databases
Date Posted: 21 Feb 2012 at 7:04pm
Hi,

I have two databases with same tables. Is there a way to link/merge these to databases. Here is an example:

Database (simplified) structure:
  - ProductData (table)
    - ProductID
    - Date
    - SoldCnt

I have two databases (not 2 tables from same database) for each store (Store1 and Store2). I want to display a merged report of these stores, like:
Store1
Product   Date   SoldCnt
   1     01-Jan    75
   1     02-Jan    85
   1     03-Jan    89
   2     01-Jan    91
   3     01-Jan    80
   3     03-Jan    88

Store2
Product   Date   SoldCnt
   1     02-Jan    92
   2     03-Jan    75
   3     01-Jan    84
   3     02-Jan    94
   3     03-Jan    97

Report
     01-Jan  02-Jan  03-Jan
1      75     177      89
2      91       0      75
3     164      94     185

        | Date
--------+---------------
Product | Sum of SoldCnt

Thanks in advance.


Print Page | Close Window