if recordnumber mod 2 = 0 then
But now I had to hide some rows bases on a formula, let's say:
But now all off a sudden I got irregularities in my alternating row coloring, like this:
After some thinking I created a Running total call Counter:
As Type of Summary I used count. As a formula I used:
The opposite of the suppressing formula.
I then replaced the formula for the alternating row coloring with
And my report was working again!