alternate group no - shading issue

[mart10]

I am using CR 11

I know how to do simple alternate shading based upon group no :

In the detail section expert click on the color tab and then the x+2 and enter the following

If remainder(recordnumber,2) = 0 then crsilver else crNoColor

But the problem is the Group no I show in the report. I have several groups and also I only show the maxium record within a group. I drop the group no into the report and take a look-->I can get data such as follows which is correct :

1
2
8
11

But I want to alternate the colour so 1 and 8 to grey for instance and the example I give is just random so I cant purely decide the colouring based upon this group no as per the simple formula I give above. How can I get around this?

 

[Charliy]

create a Running Total that does a Distinct Count of the field you're grouping on. Leave Reset as Never.
Place it in your group footer (or header if that's what you're printing) and suppress it.

Use it like recordnumber.