Crystal Reports select non match question

I have a report where the primary file links to a secondary file to obtain some data. Only the matches will be printed on the report. I need to change the report, so that all primary records will be printed regardless of wheter they are a match. I will need to be able to label the non matches in the report. How do I do that?
qbjgqbjgConsultantAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raghavendra HullurSoftware DeveloperCommented:
Hi,
When you say primary file links to a secondary file, are you using the text files as data source?
If there is a join, then you can make it a outer join instead of inner join under database expert --> Links --> Link Options.
And regarding labeling non matches, you can create a formula and compare the fields which are used for join and when values are not equal, you can use background color highlighter.
This can be explained further once you confirm on your data sources and linking and also, if possible, share a copy of report with saved data.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
qbjgqbjgConsultantAuthor Commented:
These are data base files. I had decided to use a left outer join. I will not be able to try it until Monday. So I believe the question issolved.
0
qbjgqbjgConsultantAuthor Commented:
Thanks
0
Raghavendra HullurSoftware DeveloperCommented:
Since, this question has become inactive and the author hasn't updated on the solution provided, requesting to close this question.
0
qbjgqbjgConsultantAuthor Commented:
Yes close it.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.