I have a crystal report utilizing the shadow text feature to print our pick tickets along with a packing slip. I am running into a road block on everything thing I've tried, we want to suppress some miscellaneous items on the packing slip, any charge items or comments, we want the item type 5 items to show on the packing slip. I assumed it was a simple formula but for some reason I am getting the charge items, I tried changing the item type in this formula to 4 but it still produces the charge items and no misc items. I don't have anything on the actual item code field. This suppression formula is on my details C line
formula = not( {@ShadowText}= "WT" )or not({SO_PickingSheetWrk.ItemType}="5")
Details B suppression below
formula = {SO_PickingSheetWrk.LotSerialSeqNo} > "00000000000001" or {SO_PickingSheetWrk.ItemType}="5" or _ {SO_PickingSheetWrk.ItemType}="4" or _ {SO_PickingSheetWrk.UDF_PROCESSED_IC}= "Y" or _ {SO_PickingSheetWrk.ExplodedKitItem}="Y" or _ ({@IncludeBackOrderQuantityInQuantityOrdered} = "N" and {@IncludeBackOrderedLines} = "N")