Monday, March 12, 2012

Report Builder Conditional Formatting

Does Report Builder support Conditional Formatting?Yes,
Practically every attribute of a report can be set by an expression.
For example, to get the greenbar look I use the following formula in the
BackgroundColor property of a table row:
=iif(RowNumber(Nothing) Mod 2,"WhiteSmoke", "LightGrey")
This is done using the "Expression" selection.
Hope this helps,
Russell
"Dan Krish" <Dan Krish@.discussions.microsoft.com> wrote in message
news:313AFC9A-4C70-48A4-A2BC-E38448EED70C@.microsoft.com...
> Does Report Builder support Conditional Formatting?|||Thanks!!! it helps
"Russell Hardie" wrote:
> Yes,
> Practically every attribute of a report can be set by an expression.
> For example, to get the greenbar look I use the following formula in the
> BackgroundColor property of a table row:
> =iif(RowNumber(Nothing) Mod 2,"WhiteSmoke", "LightGrey")
> This is done using the "Expression" selection.
> Hope this helps,
> Russell
>
> "Dan Krish" <Dan Krish@.discussions.microsoft.com> wrote in message
> news:313AFC9A-4C70-48A4-A2BC-E38448EED70C@.microsoft.com...
> > Does Report Builder support Conditional Formatting?
>
>

No comments:

Post a Comment