troubleshooting Question

Crystal Report GH Suppress Formula not acting as expected

Avatar of Tina K
Tina KFlag for United States of America asked on
Crystal Reports
10 Comments1 Solution163 ViewsLast Modified:
Hi Experts;

I have a three part formula used to suppress a group header when all of that group's details are suppressed. I had to use a three part formula since the actual suppression condition is a formula, which can't be summarized.
The three part formula itself is working fine, I've got the reset formula in the group header, the increment/counter formula in the details, and the totals formula in the group footer.
However, the group header suppression seems like it's suppressing based on the count of the previous group.
Here's without any GH's suppressed:
suppress1I blocked out the actual customer name, but you can see their ID number to the very left.  All customer group headers should remain unsuppressed except for C01453 and C01454 - all the detail records are suppressed and the formula @totals accurately shows 0.00
When I place the formula {@totals}=0 in the suppress area of the section expert for the group header, here's what I'm getting:
suppress2Group header for C01067 got suppressed, and while C01454 did suppress as expected, C01453 is still showing and should not be.
I've experimented with my formulas in all the various header/footer sections, and nothing seems to give me the result I'm expecting.
Any advice is appreciated!
Join our community to see this answer!
Unlock 1 Answer and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros