Skip to Content
Jan 10, 2019 at 07:05 PM

Crystal Reports 13: Comparing Two string fields



I need to write a formula that compares two fields and then shows if that comparison does not match and/or is missing then displays those conflicts.. I'm trying to research this online b/c my Crystal training really didn't go into Formulas as I have to take the advanced training.

For instance I have a field called

{PMEQMT.EQNO} and another field called

{rpt_Cycles_Wimmerton_.Tool-Code Text }

Both of these fields should have matching tool numbers. However, I know that is not the case for 500+ records. PMEQMT.EQNO is from our ERP system and rpt_Cycles_Wimmerton.Tool-Code Text is from our Access database. So, I'm trying to show what is missing or mis-aligned in our Access database.

PMEQMT.EQNO is where every item has a tool number. rpt.cycles wimmerton is the field that is missing or has incorrect tool numbers. I need to add this formula to my report to show the missing or incorrect/not matching tool numbers.