Friday, February 24, 2012

is first item in the group

Hi all,
I have the report layout like this:
Group1
Item1
Item2
...
Group2
Item1
Item2
...
...
I would like to alternate the background color on Items and Item1 always
starts with the same color and alternate from there for the rest of the
items in that group. How can I do it? I use IIF(RowNumber(Nothing), color1,
color2) but it does not work with item1 being the same color for every
group. Please advice. Thanks.I got it. Thanks.
"testing" <@.hotmail.com> wrote in message
news:%23MVQfSzIFHA.732@.TK2MSFTNGP12.phx.gbl...
> Hi all,
> I have the report layout like this:
> Group1
> Item1
> Item2
> ...
> Group2
> Item1
> Item2
> ...
> ...
> I would like to alternate the background color on Items and Item1 always
> starts with the same color and alternate from there for the rest of the
> items in that group. How can I do it? I use IIF(RowNumber(Nothing),
color1,
> color2) but it does not work with item1 being the same color for every
> group. Please advice. Thanks.
>

No comments:

Post a Comment