Group ..Alternate color ....Help Needed!

Hi,
I'm using the following in the colorbackground of the group header
to change the color of the group when a group name changes.
=iif(RowNumber("DTM_Group1")Mod 2, "White", "Cornsilk")
But this is not working properly when the group name changes!
Could some one help me with this?groupname changes ? means ?
"c4raj" wrote:
> Hi,
> I'm using the following in the colorbackground of the group header
> to change the color of the group when a group name changes.
> =iif(RowNumber("DTM_Group1")Mod 2, "White", "Cornsilk")
> But this is not working properly when the group name changes!
>
> Could some one help me with this?
>|||I have created a Group by name DTM_Group1 in the table.
Whenever the value in the DTM_Group1 changes, I want the color should
be changed.
Just like alternate coloring the rows, I want the color to be changed
on the group.|||Try this instead:
=iif(RowNumber("DTM_Group1") Mod 2 = 0, "White", "Cornsilk")
"c4raj" wrote:
> Hi,
> I'm using the following in the colorbackground of the group header
> to change the color of the group when a group name changes.
> =iif(RowNumber("DTM_Group1")Mod 2, "White", "Cornsilk")
> But this is not working properly when the group name changes!
>
> Could some one help me with this?
>|||Try with RowNumber(Nothing) / ROwNumber()|||Tried... No luck!