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!