Print Page | Close Window

suppressing multiple fields based off one field Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Technical Questions Forum Discription: Formulas, charting data, Crystal syntax, etc. URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22667 Printed Date: 30 Apr 2024 at 5:31pm Topic: suppressing multiple fields based off one field Posted By: Tori_Dee Subject: suppressing multiple fields based off one field Date Posted: 10 Sep 2018 at 9:17am 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! Replies: Posted By: DBlank Date Posted: 14 Sep 2018 at 5:19am if it is all on the same row then just use a suppression criteria on the field as InStr({rpBySample.SampID}, 'RE') <> 0

Print Page | Close Window