http://reddymsbitools.blogspot.com

Monday, 18 October 2010

SSRS Display a Grid with Alternative Colours

In SSRS, there is no straightforward way to display a grid in alternative colours. (Displaying your girds in alternative colours will improve readability of your reports. In Excel 2007 you can do this very easily but not in SSRS)

By combining an expression in the background colour and the RowNumber function, you can add alternative colours to your reports.  RowNumber(Nothing) returns row number of the current record.  For the background property of the each text box, you need to give following expression.

=iif(RowNumber(Nothing) Mod 2, "LightBlue", "SkyBlue")

No comments:

Post a Comment