Crystal Report formula question

Hey all,

I hope there is someone here that can help me.

I am making a crystal report which i'm hoping to use to better some efficiency here in the office.

This report will simply compare one table, to the other table and suppress if there is a variable that is equal.

So the report is laid out something like this

Model Number

                               Frozen Warehouse                Scanned Warehouse

If that is the way it was laid out, that would be best case scenario, i would just do

if {Frozen.warehouse}={Scanned.Warehouse} then true else false

However, most of the time i get this

Model Number
                                       Frozen Warehouse             Scanned Warehouse
                                       Frozen Warehouse
                                       Frozen Warehouse
                                       Frozen Warehouse
                                       Frozen Warehouse

Of even sometimes


Model Number
                                       Frozen Warehouse             Scanned Warehouse
                                       Frozen Warehouse             Scanned Warehouse
                                       Frozen Warehouse
                                       Frozen Warehouse
                                       Frozen Warehouse

How would i do a suppression if scanned warehouse(s) is equal to ANY one of the frozen warehouses (Mind you they are not the same number.)

Thanks in advance!

More Content