Comparing Data

[Lucieann]

I am trying to compare data in two tables. I have a master table and a purged table. I want to compare the two tables to where if a record exists in the purged table, I do not want it to print on my report. The formula I created did not work. This is what I tried:

If {nosig.Account #} <> {nosig.Purge} then { nosig.Account #}

 

[crystalreporting]

Can you use a NOT EQUAL TO (<>) join (assuming an ODBC type connection)?

Peter Shirley

http://www.linkcorp.com

 

[SmpTraining]

One way is to join the two tables with a Left Outer Join Type and conditionally supress the details you don't want to see.

The formula to supress the lines would be:

MAINTABLE.LinkedIDField = PURGETABLE.LinkedIDField

Steve Phillips, Crystal Consultant

 

[Lucieann]

I can't seem to change my join type. The options are all inactive. It is defaulted to and equal join.