I have a file where most of the information is under the year 2008. However a few records are not in 2008, so I want to pull them from 2009, but I only want those that are not included in 2008. I am trying to write it in Crystal. The files involved are an employee file that is linked to a fixed cost distribution file with an acct#. That is the file that is by year. A few emploees do not have a record in the 2008 file. The acct# we want is the one for 2008 unless it is missing, then we want the 2009. Some employees also have multiple accounts.
I tried linking (with a left outer join) to the 2008 and the 2009 by the employee# only so I could then choose the 2009 account if the 2008 was missing. This works except that I am getting multiple records where the acct# is different or there are multiples. If I include the acct# in the link, then I do not get the 2009 when the 2008 is missing. My Crystal does not allow a full outer join which I believe would work. I also tried using the add command and building 3 "files" . Then linking them together, but I still have the same issue.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Not that it's the best solution but you can accomplish a full outer join by not linking the tables in the crystal editor...
I'd consider creating your own sql with a subquery. Something along these lines:
select a.*
from 2008table a
union
select b.*
from 2009table b
where b.employeeid not in (
select employeeid from 2008table
)
Business Accounts
Answer for Membership
by: reb73Posted on 2009-02-27 at 14:54:52ID: 23760366
Can you post the code you have along with sample data from the 2008/2009 tables..