Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help on finding "Unmatched" records between the two reports

Status
Not open for further replies.

riceking704

Technical User
Jun 19, 2009
2
0
0
US
Hi All,

I am running into this problem when I tried to create a Crystal Report to find "Unmatched" record between two existing reports with the common field is PartID.

Could anyone please show me how to do this on Crystal Report XI? (right now I have to export data from those 2 reports to MS access database and using Find Unmatched Wizard to get data)

Thanks a million

Riceking704
 
Do you really mean between two reports or between two tables? If these are really two different reports, you need to tell us what tables are used in each and also show us the record selection formulas for each.

-LB
 
you are correct, it is between the two reports.
They are both using the same tables: PLO_Main and PTS_Main but they are using different select criterias.

My goal is to pull the unmatched records (by PartID) between the two reports

Thanks for your help!!!

Riceking704
 
Please show the content of the two sets of selection criteria.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top