I have an invoicing report where I need to suppress certain data if it is a re-analysis. I am able to suppress data that says it is an "RE" but I don't know how to suppress the remaining data associated with it.

ie.

sampID    Ref#    Analysis          Price    Surcharge
3D90-RE   12345     metals          $123.45     0.0%

I created a formula for the SampID field:

If InStr({rpBySample.SampID}, 'RE') = 0 then {rpBySample.SampID}

I need all the other fields to also not show up if "-RE" is in the sampID field.

Thanks in advance!