Highlight Alternate Rows Issue

Hi,

(if RecordNumber mod 2 = 0 then crSilver else crNoColorwell )

Using this formula worked well in one report of mine but in another report its colors all the rows.
The only difference is in the report that it is not working has another formula present to suppress duplicates in the detail section.
{Origins.Time}=previous ({Origins.Time})
When I delete this formula the alternate color works but I have unwanted duplicates.
Is there an easy way around this ?
Thanks!

Swap out RecordNumber with a Running Total. The RT should be a count that uses the same criteria expression to exclude those rows from the count.
For duplicates it sometimes can be as easy as doing an distinct count.