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).
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
Concepts
Designing the Report Layout
Formatting Numbers and Dates
Using Parameters Collection References in Expressions (Reporting Services)
Adding Parameters to Your Report
Tutorial: Adding Parameters to a Report
Using Expressions (Reporting Services)
Using Custom Code References in Expressions (Reporting Services)
Other Resources
Tutorials (Reporting Services)
Using Custom Assemblies with Reports
Help and Information
Getting SQL Server 2008 Assistance