Formula for unmatched data

[RaoulZa]

Hi

I am developing a report using two tables from two seperate audit reports. I need to find out the expressions to be used in a formula that will compare the identity field of one table against the identity field of the other table to see if there are any mismatches.

For example - M12345 is the hardware identity in the current audit, but it is missing in the past audit ( making it a new piece of hardware ).

If anybody could help I would be most grateful.

Thanks

 

[dgillz]

Link the two tables using an equal to link, and place both fields that should contain "M12345" on the report.

Then Write a record selection formula:

IsNull(Table1.Field}) or IsNull({Table2.Field})

This will return only those records in ONE table or the other, and your report will show which one is missing. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[RaoulZa]

Thanks for that - I am on the way there, but i now have three columns of data.

Is there any way to suppress the unwanted data (i.e. the matching stuff ) so that only the fields that do not match are shown?

 

[dgillz]

The record selection formula will do this for you. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com