Reporting Services Row Background Color

At times we will need to vary the colors of our rows based on the data or readability. This can be accomplished by editing the row background color property. Below I’ve created a report that will highlight any rows that have a ship country of France or a contact name of Yang Wang.

To accomplish this simply select the detail row in the layout view.

In the properties window select “Expression” from the dropdown listed next to BackgroundColor.

An expression window will open. Put your IIF statement here.

You can also use the FontStyle row property to change a row style to italics.