You can base the formatting of text on the value of the data to highlight items in your report using expressions in the style properties of the report item. For example, in an employee list, you can render the names of sales managers in bold with the following expression in the FontWeight property:

=iif(Fields!Title.Value = "Sales Manager", "Bold", "Normal")

Green Bar Reports

A commonly used report style which requires conditional formatting is the green bar report. To apply this style to the detail row in a table, select the detail row and use the following expression in the BackgroundColor property:

=iif(RowNumber(Nothing) Mod 2, "PaleGreen", "White")

Red Negatives

Another commonly used style which can be acheived using conditional formatting displays any negative dollar values in red. This can be accomplished using the following expression in the Color property of the textbox:

=iif(Fields!GrossProfit.Value < 0, "Red", "Black")

Highlighting

You can also highlight certain values, for example if you want to track sales of all products with a unit price of over $100, you can use the following expression in the BackgroundColor property of the UntiPrice textbox:

=iif(Fields!UnitPrice.Value > 100, "Yellow", "White")

As you can imagine, with more complex expressions the possibilities are virtually endless.

See Also