Adding Conditional Formatting

Adding Conditional Formatting

SQL Server 2000

You can design a report so that different styles are applied to items based on the data in the report. For example, negative numbers in a report can be displayed in red.

To make styles dynamic, use an expression instead of a static value for the style properties of the item. For example, to make a text box return a negative value in red for the field Profit, use the following expression in the Color property of the text box:

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

Creating a Green-Bar Report

To apply a green-bar effect (alternating colors every other row) to a table in a report, use the following expression in the BackgroundColor property of each text box in the detail row:

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

You can build expressions based on a number of functions. For more information, see Using Expressions.

See Also

Defining Report Appearance

© 2015 Microsoft