Wednesday, October 6, 2010

How change the color of row in SSRS Reports

=iif(RowNumber(Nothing) mod 2, "Beige", "WhiteSmoke")
by using this code in expression the color of the row changed 1st row "Beige" and 2nd row "WhiteSmoke"
=FormatCurrency(Fields!Total_DO_Value.Value,2)
The above expression is used for the Currency Format
=IIF(Fields!Contractual_StartDate.Value IS Nothing, "" ,FormatDateTime(Fields!Contractual_StartDate.Value,2))
The above expression is used if StartDate is nothing then display blank space i not then display the date.

 

1 comment:

  1. =iif(RowNumber(Nothing) mod 2, "Beige", "WhiteSmoke")


    what is this nothing means

    ReplyDelete