I have a report with multiple groups where I would like to alternate row color in the group footer. I have seen the tip where one makes a running count of the groupnumber and then evens have color and odds don't. But that doesn't work in this instance since there are mupltiple groups and I only want to alternate colors for the footers of 2 of the 6 groups. In this case want to alternate colors for group footers 6 and 5 (i.e. 6 and 5 together would have no color and then the next 6 and 5 would be silver etc.) How could I alternate in this case?

Thanks Jyothi, but that doesn't work in this case (I think it is basically the same idea as the running total). It calculates group numbers for all of the groups in the report but since I am surpressing some groups the calculation doesn't work to alternate on just groups 6 and 5 which are the displayed groups.

I agree with DBlank, I would use a variable and only increment it when it is appropriate.  In your case I believe I would increment it in GF6, but if you have multiple GF6 inside of GF5...OK, if you want GF5 and 6 to match, I would increment the variable in GH5, this way, ALL GF6 and GF5 will be the same for a GF5.  Then the changing of the color is easy.

Not that I am aware of but you can accomplish the same thing via a variable (lockwelles preference) or a Running Total (my preference).

So when you applied Jyothi's approach you did not get what you wanted because synching on the 5-6 grouping even though there is a 1:1 relationship between them ? So the question is what is the group level that keeps it synched for your coloring issue? Once you identify that you use. It is likely whatever the field that you are using for group 5.

Edited by DBlank - 25 Sep 2009 at 11:43am