Shading on Alternate Rows 2

[jemsmom]

I'm trying to alternate gray and white row shading in a summary report in a group footer row. I've used the following steps in the detail row of previous reports, but it does not work in the group footer. There is not an alternating pattern, its appears random. Does anyone have any other ways to accomplish alternate shading?

1. Select the Section Expert toolbar button to open the Section Expert window.
2. Select the Details section and click on the Color tab. Check the Background Color checkbox and select the X+2 button (conditional formatting).
3. Enter the following formula in the formula window:
iif(Remainder (RecordNumber,2)<>0,crSilver,crWhite)

 

[MJRBIM]

The GroupFooter rule should be based on the Remainder of the GROUPNUMBER - not the RECORDNUMBER.

RECORDNUMBER only works in the detail section.

 

[jemsmom]

Thank you. That solved the problem!