Print Page | Close Window

Joining mirrored tables

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4674
Printed Date: 02 May 2024 at 7:33am


Topic: Joining mirrored tables
Posted By: db3712
Subject: Joining mirrored tables
Date Posted: 30 Oct 2008 at 9:39am

I am trying to run a report that will pull data from two tables.  One is open orders and the other is closed.  We now create two different reports.  Any ideas on how to accomplish this?  I appreciate any ideas.


Replies:
Posted By: rahulwalawalkar
Date Posted: 31 Oct 2008 at 1:54am
Hi,
 
You can Join the Tables in Primary Keys which could be Order ID'S in both the tables,and then you may have some status field which tells you when the Order is Closed Or Opened
 
Cheers
Rahul
 
 
 
 
 
 
 
 
 
 
 
 
 
 


Print Page | Close Window