Conditional formatting of negative numbers SSRS

Formating text depening on its value - sql server reporting services

The formula below will format a field to red if it is a negative number. The formula goes into the reports Font color property for the field you are highlighting.

=IIF(Fields!FieldName.Value<0, "Red","Black")

Don't forget the subtotal and total rows"

=IIF(Sum(Fields!FieldName.Value)<0, "Red","Black")

Categories: Development
Permalink | Comments (0) | Post RSSRSS comment feed