Monday, 25 January 2010

Alternating colours

How to use alternating colours in a table created in ssrs

Highlight the row or the cell in the details section of your report and then in the properties window in background (under Appearance). Select the Expression and in the Expression box
type in the following code.

=iif(RowNumber(Nothing) Mod 2, "silver", "White")
=iif(RowNumber(Nothing) Mod 2, "White","#fff4cb")
=iif(RowNumber(Nothing) Mod 2, "White","aliceblue")

You can use custom clours as well.

To use the custom colours create a custom colour in the expression window then double click the colour and the code will appear in the text box.

For alternate colours in a matrix row group use :

=IIf( RunningValue (Fields!FIELDNAME.Value, CountDistinct, Nothing) MOD 2, "Transparent", "aliceblue")

No comments:

Post a Comment