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))
=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