Skip to Content
0
Jan 04, 2019 at 03:18 PM

Crystal Reports 2013 Suppressing a field based on a condition

1196 Views

Hello,

I have created labels in Crystal that include a 'Item Number' field and a 'PO' number field.

However our customer wants to suppress the PO number if it does not equal an item number that starts with '1.CLA*'. So, I right-clicked on the PO number field and suppressed it using this formula but it wants to suppress the PO number for all items numbers instead of all item numbers but 1.CLA*.

{ARINVT.ITEMNO}<> "1.CLA*"

I also tried some other formulas using IF THEN statements but can't get it to work. I've searched the web, etc and can't seem to find a direct answer. Thanks!