Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Suppress Based On Multiple Conditions Post Reply Post New Topic
Author Message
jlalonde
Newbie
Newbie


Joined: 08 Jan 2016
Online Status: Offline
Posts: 2
Quote jlalonde Replybullet Topic: Suppress Based On Multiple Conditions
    Posted: 09 Aug 2018 at 9:19am
I'm looking to create a formula to suppress a text module based on whether or not certain part numbers are in a job.

We have the following formula that suppresses an image based on a single part:

{BAQReportResult.JobAsmbl.PartNum} <> "XXXXXXXX"

This works but we want to add additional parts to the formula. Any ideas on how to accomplish this?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 09 Aug 2018 at 9:52am
just add an AND + the next condition.
Unless you are trying to do group conditions.

{BAQReportResult.JobAsmbl.PartNum} <> "XXXXXXXX"
AND {Table.ColorField} = 'Red'
AND {table.numberfield} in 1 to 5
...
IP IP Logged
jlalonde
Newbie
Newbie


Joined: 08 Jan 2016
Online Status: Offline
Posts: 2
Quote jlalonde Replybullet Posted: 09 Aug 2018 at 9:56am
Maybe I didn't explain myself well... I'm pretty sure I didn't.

What we want to do is have a text field that says WHITE... And suppress or show it based on certain parts... So, I thought it would be something along the lines of:

{BAQReportResult.JobAsmbl.PartNum} <> "XXXXXXXX" or "ZZZZZZ" or "YYYYYY"

So there's multiple parts that require it to be suppressed or not suppressed. Would the formula you provided work for that?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 09 Aug 2018 at 9:58am
I think you are asking for this...
NOT (
{BAQReportResult.JobAsmbl.PartNum} IN ["XXXXXXXX","ZZZZZZ","YYYYYY"] )
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.016 seconds.