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

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

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