I was looking for a way to do this easily in SQL Reporting services. Not as easy as Excel but this gets the job done. You can multi-select cells and add it as the background for all of them which is very handy. Credit to Michael Haren on stackoverflow.
Go to the table row's BackgroundColor property and choose "Expression..."
Use this expression:
=IIf(RowNumber(Nothing) Mod 2 = 0, "Silver", "Transparent")
No comments:
Post a Comment