This one is pretty simple and can be handled in an expression.

Expression

=iif(RowNumber(Nothing) Mod 2, “White”, “Gainsboro”)

According to the expression first color (White) will be the background color of the first line in the dataset. The second color (Gainsboro or light gray) will be the alternating background color.

To apply this right-click the dataset cell for which you would like the alternating background color applied to, then click

“Textbox Properties”.

Image

Next, select Fill from the right sidebar and click the “fx” next to the fill color.

All that remains is to paste the expression into the textbox and you’re done. The only pain in this process is that you’ll need to select each individual cell in each dataset in order to change its background color. Report Builder does not support the selection multiple textbox properties within a dataset.