Conditional Suppression Formula

How can I write a conditional suppression formula to suppress the repeated word "Color"? I can't use the suppress duplicate feature for this field since we use it for other things that must be repeated. I have the Test#200 suppressing because that one has to be suppressed all the time. In some cases Test#177 has to show the word "Color". In this case, there is a Test #116 present and when this test is present along with #177 and #200 the word "Color" field = {LabMethods_ReportedName} should only show for Test ID#116 and suppress for #200 and #177. I tried to do a conditional suppression on the Duplicate Suppression but it didn't work for me. Maybe I did that incorrectly.
RP_CofA_Form.rpt
Example.docx
Joe BrownIT ManagerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
Are there other conditions that require  the suppression of Color?

Try this idea

Add a formula to the report (doesn't have to be on the report)
Name - Has116
if {RP_MaterialSpecs_Tests.RP_MS_TestID} = 116 then
    1
Else
    0

Open in new window


Name - Has200
if {RP_MaterialSpecs_Tests.RP_MS_TestID} = 200 then
    1
Else
    0

Open in new window


Use this formula for the suppression
{RP_MaterialSpecs_Tests.RP_MS_TestID} = 200
or
Sum({@Has116}) <> 0 AND Sum({@Has200}) <> 0 AND {RP_MaterialSpecs_Tests.RP_MS_TestID} = 177

Open in new window


mlmcc
RP_CofA_Form-rev1.rpt
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Joe BrownIT ManagerAuthor Commented:
Worked like a charm! I did start off with that concept in mind by forget about the Summing that is necessary. Thank you so very much for your fast and helpful reply!!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.