=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.
=iif(RowNumber(Nothing) mod 2, "Beige", "WhiteSmoke")
ReplyDeletewhat is this nothing means