SSRS, if the line says this, then change it to this

Question

I have a field in SSRS and it returns from SQL saying "Incomplete"

In SSRS, I want to say that at any time this field says “Incomplete” to change the line to “Pending”

This should be done in SSRS.

Thank!

Answer 1

Just use the expression:

=iif(Fields!Field1.Value="Incomplete", "Pending", Fields!Field1.Value)

Answer 2

On top of my head you can do something like:

=Replace(Fields!thisItem.Value, "Incomplete","Pending")