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!

  • 0

    You can suppress a detail row by right clicking on the Details Section and then clicking on the blue X2 next to Suppress and put in {Frozen.warehouse}={Scanned.Warehouse}.  It is also in any book on Crystal.

  • 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.

  • 0

    Hi there.  I may be missing something, but instead of using the field to print "Frozen Warehouse" and 'Scanned Warehouse" create two always suppressed variables and put them on the left side of the detail line each with the logic pointing to the field you want to print, say @frozen and @scanned, then create another variable (@print) on the detail line which will print and will compare @frozen to @scanned and if equal (or if both are not empty or null, i.e. a value in each variable on that line) it will suppress else it will print.

    Let me know how it works or I need additional clarification.

    Van

  • 0 in reply to VanMan

    Unless i'm missnderstanding, it is going to be the same issue. It is going to print everything that isn't equal

    Frozen Warehouse    Scanned Warehouse

    000                                 003                    Not Equal

    003                                 003                     Equal

    021                                 003                     Not Equal

    But rather i'm looking for more If Scanned warehouse(s) is not in Frozen Warehouses then print,  otherwise suppress.

    Am i misunderstanding? Or would that still give me the same result?

  • 0 in reply to idunham

    You can build in If then logic for the @print field to compare the values for the @frozen and @ scanned.  Can you email me your report that you have so far? van_at_mas90support.com

  • 0 in reply to VanMan
    SUGGESTED

    Go to the design view on your report and right click on the word Details and then select Section Expert... in the popup window.  In the selection expert click on the X2 icon to the right of Supress (No Drill Down).  In the formula section put in {IM_Physical.WarehouseCode}={BC_DetailRejection.AlternateWarehouseCode} and click Save and Close.  This will suppress all lines where the two warehouse codes are the same, but print the rest.