I have a report grouped by (3)Line within (2)Order within (1)Customer.
(D)Detail lines are built from data read in with a SQL Query. The only formula is the (D)Barcode field, which is converted to a numeric.
There can be multiple occurrences of (D)Detail lines for a (D)Barcode if there are multiple scans. Another field in the (D)Detail line is (D)Qty, which is simply read in, and will always be the same within the set of (D)Detail lines within a (3)Line grouping.
The footer of the (3)Line group has two formulas, one is Summary which is max of (D)Qty, and the other is Running Total of distinct (D)Barcode. If these two numbers are the same, the (3)Line footer display is suppressed.
Now if all goes well, I will have very few instances where these two numbers are not the same. Problem is even though I have nothing eligible to display, the (1)Customer header is still displayed.
I know where to go to suppress the (1)Customer group, but I can't seem to get it right. I know evaluations can be tricky, but can someone give me pointers on what to look for, and what to look out for?