Crystal Reports rows in group with alternating colors
I have a Crystal Report that has the following:
Group #1 Header Test1
Group #2 Header Test2
Group #3 Header Test3 Sum(A) Sum(B) Sum(C)
Group #2 Footer Grand Total Sum(A) Sum(B) Sum(C)
Group #1 Footer Grand Total Sum(A) Sum(B) Sum(C)
Go to Section Expert for Group #3 Header then to Color tab and click on Formula button and add:
if recordnumber mod 2 = 0 then
*** This works fine if the data was in a Details section since the recordnumber is in order .... but since its a Group Header the recordnumbers are all over that place because the grouping is doen after.
Question is how do I make alternating colors in the Group #3 section. What formula could I use to get the recordnumber after the grouping has occurred.