<p>How do you shade alternating rows in a SQL Server Reporting Services report?</p>

<hr>

<p><strong>Edit:</strong> There are a bunch of good answers listed below--from <a href="https://stackoverflow.com/questions/44376/add-alternating-row-color-to-sql-server-reporting-services-report#44378">quick</a> and <a href="https://stackoverflow.com/questions/44376/add-alternating-row-color-to-sql-server-reporting-services-report#345935">simple</a> to <a href="https://stackoverflow.com/questions/44376/add-alternating-row-color-to-sql-server-reporting-services-report#83832">complex and comprehensive</a>. Alas, I can choose only one...</p>

Go to the table row's BackgroundColor property and choose "Expression..."
Use this expression:
```
```
= IIf(RowNumber(Nothing) Mod 2 = 0, "Silver", "Transparent")
```
```
This trick can be applied to many areas of the report.
And in .NET 3.5+ You could use:
```
```
= If(RowNumber(Nothing) Mod 2 = 0, "Silver", "Transparent")
```
```
Not looking for rep--I just researched this question myself and thought I'd share.