Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
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