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:
Go to the report designer of the Customer report from the previous example.
Click on the row header for the details record (third row in the Tablix).
In the Properties window, find the Background Color property and click on your desired color from the color picker menu.
Choose Expressions from the color picker pop up as shown in the following screenshot:
In the Expression editor window, enter the following script:
=iif(Fields!Gender.Value="M","Light Green","Khaki")
Close the Expression window and preview the report. You will see that male and female data rows are now different with regard to background color, as shown in the following screenshot:
