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!
