Wednesday, July 1, 2015

SSRS If condition and date function

Date dd-mm-yy to MonthName
=MonthName(month(Fields!ClosedDate.Value), false)
IF condition
=IIF(Fields!Profit.Value < 0, “Red”, “Black”)
=IIf(IsNothing(Fields!ClosedDate.Value),0,”MonthName”)
Date with IF condition
=IIf(IsNothing(Fields!ClosedDate.Value),0,MonthName(month(Fields!ClosedDate.Value), false))

No comments:

Post a Comment