I am having an issue with alternating colors in a Crystal Report. I have several groups and the alternating colors formula is in Group six the formula I am using is:
if groupnumber mod 2 = 0 then
However, it's works fine on pages 1 and 2 then it gets funky on page 3 where it highlights 2 rows with the same color then 2no color then 6 with color 1 without.
Is there something wrong with the formula or is there a different formula I should use so that the shading is consistent throughout the report.
Any help greatly appreciated.