IIF Statement with Dataset fields SSRS

Question

I have the below expression

= IIF(Parameters!RepoLetterType.Value=2,"HI Fields!PaymentDueDate.Value " ,"")

In this I need to write "The Letter Dated July 23 is being Printed with the value of 3000" in the else part of IIF Statement. The date and value will come from dataset field.

I am trying to build this but am getting error. Please help

Answer 1

To combine text and fields, the static text is within double quotes and combined with fields with an &.

= IIF(Parameters!RepoLetterType.Value=2 
    ,"HI " & FORMAT(Fields!PaymentDueDate.Value, "MMMM d") 
    ,"The Letter Dated " & FORMAT(Fields!PaymentDueDate.Value, "MMMM d") & " is being Printed with the value of " & FORMATNUMBER(Fields!PaymentAMT.Value, 0)
    )