Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide

Time for action – changing the background color of data rows based on expressions

In this example, we want to distinguish records for male and female customers by changing the background colors of the row. For this purpose, we will write an expression and use that in the background color property of the data row using the following steps:

1. Go to the report designer of the Customer report from the previous example.
2. Click on the row header for the details record (third row in the Tablix).
3. In the Properties window, find the Background Color property and click on your desired color from the color picker menu.
4. Choose Expressions from the color picker pop up as shown in the following screenshot:
5. In the Expression editor window, enter the following script: ...