If the remainder is 1, then the row number is odd, and if it is two, the row number is even. In this case, the expression returns the remainder of a division in which the row number is divided by two. The Mod operator stands for “modulo,” which returns the remainder of a division. By using “Nothing,” we tell it that the scope is the entire report, so that row numbers start with 1 on the first row and just keep counting up through the entire report (if we had wanted to reset row numbers at the start of every group, for example, we would have put the name of the group in the parenthesis, delimited in double quotes). Inside the parenthesis, we specify the scope, or when we want the row number to reset to 1.
Here’s how that expression works: RowNumber() is a function that returns the current row number when the report runs. Type the following expression into the Expression Builder window (ignore the red squiggly line it complains but it works just fine). Click the BackgroundColor property’s dropdown button and select Expression… Next, find the BackgroundColor property in the Properties Window (if you do not see the Properties Window, press F4).
In order to create alternating colors, we start by going to the Design tab and selecting the detail row in the tablix data region. Here is a simple report with alternating row colors in this case, PaleGoldenRod and LightSteelBlue:
0 kommentar(er)
