Wednesday, January 20, 2010

Expression to add alternating row color for rows in a SQL Report

Go to the table row's BackgroundColor property
Then click on the down arrow and choose "Expression..."
Enter the below code in that expression value.

= IIf(RowNumber(Nothing) Mod 2 = 0, "LightBlue", "White")

It sets the alternating row values as LightBlue and White.

No comments:

Post a Comment