Alternating row colors in a table in Reporting Servivces

When you look at a table in a Reporting Services report you might not always see very clearly which row that you are at. To help the user you can use borders or you can use alternating row colors.

At http://stackoverflow.com/questions/44376/add-alternating-row-color-to-sql-server-reporting-services-report I found the solution.

In the table row's BackgroundColor property pane choose "Expression..." and enter the following expression:

= IIf(RowNumber(Nothing) Mod 2 = 0, "Silver", "Transparent")

Or use any color that you like.

 

posted @ Friday, February 12, 2010 6:58 PM

Print