I would like to suppress a details line in a crystal report based upon a certain condition of itself. Looking for some help in writing this conditional suppression formula.
When the Test ID is 175, 176 or 212 then I need only one of those to show based upon this hierarchy.
1. If 176, 175 and 212 all exist, then 175 and 212 should suppress (only show 176)
2. If 175 and 212 exist, and 176 does not, 212 should suppress (only show 175)
3. If neither 176 or175 exists then only 212 should show
Can someone help me write this properly?