Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2016 : Technical Questions
Message Icon Topic: suppressing multiple fields based off one field Post Reply Post New Topic
Author Message
Tori_Dee
Newbie
Newbie


Joined: 25 Jun 2018
Online Status: Offline
Posts: 6
Quote Tori_Dee Replybullet Topic: suppressing multiple fields based off one field
    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!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 8937
Quote DBlank Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.