dynamic color of rows 1

[yehong]

Hi guys, I have a report in which I am currently displaying dynamic color of rows by this formula:
//@dynamic color
if (recordnumber mod 2) = 1
then
crwhilte
else
crsilver)
It works fine but only if I don't supress duplicate records. But it does not work when I use this formula to supress duplicates:
//@supress
(table1.column1)=previous(table1.column1)

Any ideas how to achieve dynamic coloring in this situation?

 

[lbass]

Create a running total {#cnt} that counts column1 and evaluates using a formula:

onfirstrecord or
{table.column1} <> previous({table.column1})

Reset never.

Then change your color formula to:

if {#cnt} mod 2 = 1
then
crwhite
else
crsilver

-LB