We help IT Professionals succeed at work.

Crystal Reports select non match question

qbjgqbjg
qbjgqbjg asked
on
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?
Comment
Watch Question

Commented:
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.
qbjgqbjgConsultant

Author

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.
qbjgqbjgConsultant

Author

Commented:
Thanks

Commented:
Since, this question has become inactive and the author hasn't updated on the solution provided, requesting to close this question.
qbjgqbjgConsultant

Author

Commented:
Yes close it.