Print Page | Close Window

Data from multiple dbases using date range

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=18082
Printed Date: 05 May 2024 at 2:10am


Topic: Data from multiple dbases using date range
Posted By: dknudson
Subject: Data from multiple dbases using date range
Date Posted: 27 Nov 2012 at 3:43am
This is probably basic stuff, but  its been awhile since I created a report and have forgotten most of my training... :(
 
I have three databases. FFINV, MasterD and MasterF. FFINV points to MasterD and MasterF using a key field and a left join.
 
in the report, if I select just off a billcode field, I get MasterF and MasterD information. If I add that I want all records from MasterF that fall between 05/01/2012 and 05/31/2012, I only get MasterF records,as would be expected. However, i need to get records from both MasterF and MasterD that fall into that date range. I cant seem to come up with the logic to get that accomplished in the Select Expert.  I can get one or the other, but not both.
 
I am using version 10 of Crystal Reports


Replies:
Posted By: shanth
Date Posted: 27 Nov 2012 at 8:31am
If I understand correct, Master D Left Join Master F, but you need Full records from Master F. Don't think so, because you already filtered Master F based on Key field joined with Master D. Select expert only filters records that are pulled from SQL based on condition.


Print Page | Close Window