! Shading Every Other Line in Group and Details Header !

[dbielenda]

I am trying to shade every other line in my report. I have a group header as well as details. I used this formula (which works fine):

if Remainder(GroupNumber,2) = 0
then NoColor
else Color (241, 241, 241).

I would like another formula (due to the the fact that I am using a Third Party Tool) that will do the same thing, does anyone have an suggestions? Any is greatly appreciated! Thanks!

 

[martink1]

what i do is go to the &quot;section expert&quot; and add a duplicate section for what ever section I want shaded. ie. details a I'll add details b. I add the same fields to each. click on the color tab and activate the background color for details a . for details a click the 'suppress no drill down' formula and add a formula: remainder(RecordNumber,2)=0 to hide all the even numbered records. then go to details b and add formula: Remainder(RecordNumber,2)<>0 to hide all the odd records.

 

[dbielenda]

I will try this, thanks for the input