Crystal Report Formula Unless Statement?

SOLVED

Hi, I have several things excluded under the Select Expert in Crystal Reports.

I'm not sure if this is even doable. Is there a unless?

not ({@RestrictZ} like ["*1*", "*Z*"]) Unless {CI_Item.UDF_BRAND} = Barebones

Any help would be appreciated.

{IM_ItemWarehouse.WarehouseCode} = "000" and
not ({CI_Item.UDF_BRAND} like ["5.11 Tactical", "Black Legion", "Boker", "Carson Optics", "Dragon by Apogee", "Fisher Space Pen", "FOX", "Gear Infusion", "Gerber", "Giesen & Forsthoff", "Havalon", "Hibben", "KeySmart", "Kit Rae", "La Siesta", "Leupold", "United Cutlery", "Viking Tactics", "Wallet Ninja", "Zero Tolerance"]) and
{IM_AliasItem.Type} = "G" and
{CI_Item.Category1} like ["3?", "3?C", "3?H", "3?M", "3?MC", "3?N", "3?NW", "3?P", "3?Z", "IT", "IT ONLY", "J", "JG", "M", "MAPLM", "MCAT", "P", "PCAT"] and
not ({CI_Item.ItemCode} like "PSP0057") and
{@Xeop} <> "No" and
not ({@RestrictZ} like ["*1*", "*Z*"]) and
{@QtyAvail} >= 1.00 and
{@Victorinox MAP} <> "VICMAP" and
not ({CI_Item.PrimaryVendorNo} in ["0000018", "0000635"])

Parents
  • +1
    verified answer

    I think this is what you want. You have to use OR but enclose both evaluations within a set of parenthesis because you want it to be an "either" condition while keeping all of your other evaluations.

    {IM_ItemWarehouse.WarehouseCode} = "000" and
    not ({CI_Item.UDF_BRAND} like ["5.11 Tactical", "Black Legion", "Boker", "Carson Optics", "Dragon by Apogee", "Fisher Space Pen", "FOX", "Gear Infusion", "Gerber", "Giesen & Forsthoff", "Havalon", "Hibben", "KeySmart", "Kit Rae", "La Siesta", "Leupold", "United Cutlery", "Viking Tactics", "Wallet Ninja", "Zero Tolerance"]) and
    {IM_AliasItem.Type} = "G" and
    {CI_Item.Category1} like ["3?", "3?C", "3?H", "3?M", "3?MC", "3?N", "3?NW", "3?P", "3?Z", "IT", "IT ONLY", "J", "JG", "M", "MAPLM", "MCAT", "P", "PCAT"] and
    not ({CI_Item.ItemCode} like "PSP0057") and
    {@Xeop} <> "No" and
    (not ({@RestrictZ} like ["*1*", "*Z*"]) or
    {CI_Item.UDF_BRAND} = "Barebones") and
    {@QtyAvail} >= 1.00 and
    {@Victorinox MAP} <> "VICMAP" and
    not ({CI_Item.PrimaryVendorNo} in ["0000018", "0000635"])

  • 0 in reply to David Speck

    And this is why I love the forums. Thank you so much and explaining why also!

Reply Children
No Data