Please help. I need to distinguish blocks of information on some reports and
I need to be able to altenate the colors.
Please advise.
Thank you.Use RowNumber(scope) function to determine the report row is odd or even and
then set its backcolor property accordingly (e.g. set report detail row's
BackColor property to an Expression, like:
=IIF(RowNumber(Nothing) Mod 2=0, "Silver","White")
Note, if your report has different groups, you need to pass a correct value
to the "scope" argument of RowNumber() function.
"assistanceappreciated" <assistanceappreciated@.discussions.microsoft.com>
wrote in message news:E63FD05E-86E1-486A-A0FF-5B90AAB8DFED@.microsoft.com...
> Please help. I need to distinguish blocks of information on some reports
> and
> I need to be able to altenate the colors.
> Please advise.
> Thank you.|||Thanks so very much.
"Norman Yuan" wrote:
> Use RowNumber(scope) function to determine the report row is odd or even and
> then set its backcolor property accordingly (e.g. set report detail row's
> BackColor property to an Expression, like:
> =IIF(RowNumber(Nothing) Mod 2=0, "Silver","White")
> Note, if your report has different groups, you need to pass a correct value
> to the "scope" argument of RowNumber() function.
>
> "assistanceappreciated" <assistanceappreciated@.discussions.microsoft.com>
> wrote in message news:E63FD05E-86E1-486A-A0FF-5B90AAB8DFED@.microsoft.com...
> > Please help. I need to distinguish blocks of information on some reports
> > and
> > I need to be able to altenate the colors.
> > Please advise.
> >
> > Thank you.
>
>
No comments:
Post a Comment