You can design a report so that different styles are applied to report items or properties based on the data in the report. You can build conditional expressions using any feature supported by expressions, including built-in report and aggregate functions, built-in collections, and custom code. For example, you can display negative numbers in red or change the background colors on a table. To make styles conditional, use an expression instead of a static value for the style properties of the item. At run time, the report processor evaluates the expression and substitutes the result for the property value, just as if you had set the property to a static value at design time. When the report is rendered, the run-time value is used.
For more information about what you can include in an expression, see Understanding Expression References (Reporting Services).
Examples
Changing Text Color Based on an Expression
Creating a Green-Bar Report
To alternate the background color for every other row in a table, you can set the BackgroundColor property for each text box in the row to the same conditional expression. This technique works for detail rows only in a table with no groups.
=IIF(RowNumber(Nothing) MOD 2, "PaleGreen", "White")
Controlling Colors in a Pie Chart
See Also