Group Footer Alternating Background Color
I have an alternating background color on my GF2, which works correctly using the code below in the section expert. However when I add a new suppressed group (GH3/GF3) to the report, the alternating is not correct as it may skip a few instances of GF2, and then color 5 instances of GF2 in a row, etc. GF2 is the only section that is not suppressed in the report.
How do I correct this?
if groupNumber mod 2 = 0 then color(235,235,235) else crNoColor