Crystal Report formula question

SUGGESTED

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!

Parents Reply Children
  • 0 in reply to BigLouie

    Where i run into an issue is if Frozen warehouse has warehouse 000 001 003 021 027  and the scanned warehouses are 000 and 003. if i do if {frozen.warehouse}={scanned.warehouse} then true else false, it will suppress 000, because 000 does exist. However, 000 does not equal 001, 003 etc etc.

    I guess i need to better state what i'm looking for

    If i have Frozen warehouse, and the warehouses are

    000

    001

    003

    021

    027

    and i have scanned warehouses of

    000

    003

    I want to suppress if Frozen warehouses contain 000 and 003. If they do not contain 000, or 003, i do not want it to not suppress.