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

Stop running SSIS Script Task after some time...

There is a SSIS Script Task which use to run another program. But due to the errors in the other program, some times script task is in the ...