Conditional Suppression Formula

Joe Brown
Joe Brown used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
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
Joe BrownIT Manager

Author

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!!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial