Set an Alternate Row Color in SSRS

Set an Alternate Row Color in SSRS

In this article, I will show you how to set an alternate row color in Tablix in Report.

1. First of all Open any SSRS report which contains Tablix.

2. Now select Details Row from Tablix.

2-Set an Alternate Row Color in SSRS

3. Then press F4 key or manually open property window. In property window select BackgroundColor Property. Then click on arrow button which is on right side and select Expression as shown in below screenshot.

3-Set an Alternate Row Color in SSRS

4. An Expression window opens. In that window paste following expression. Then click on OK button.

=IIF(RowNumber(Nothing) MOD 2,”LightGrey”, “LightBlue”)

4-Set an Alternate Row Color in SSRS

You can change color as par your requirement. Simply replace color used in above expression.

5. Now run your report. You will see results look like following screen shot:

5-Set an Alternate Row Color in SSRS

6. Similarly if you want to change row background color in specific condition like you need to change row background color when Address contains Ct. In that situation use following expression.

=IIF(InStr(Fields!Address.Value,”Ct”)=0,”LightGrey”,”LightBlue”)

Now run your report. You will see output like following screen shot:

6-Set an Alternate Row Color in SSRS

Congratulations! We successfully Set an Alternate Row Color in SSRS Report.

If any query, let me know.

For contact information, go to following link :

http://bhushan.extreme-advice.com/about-bhushan-shah/

4 thoughts on “Set an Alternate Row Color in SSRS

Leave a Reply

Your email address will not be published. Required fields are marked *