Suppress Based On Multiple Conditions
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=22656
Printed Date: 03 May 2024 at 8:46pm
Topic: Suppress Based On Multiple Conditions
Posted By: jlalonde
Subject: Suppress Based On Multiple Conditions
Date 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?
|
Replies:
Posted By: DBlank
Date 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
...
|
Posted By: jlalonde
Date 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?
|
Posted By: DBlank
Date Posted: 09 Aug 2018 at 9:58am
I think you are asking for this...
NOT (
{BAQReportResult.JobAsmbl.PartNum} IN ["XXXXXXXX","ZZZZZZ","YYYYYY"] )
|
|