SSRS if string says this then change it to this

I have a field in SSRS and it returns from 开发者_运维知识库SQL saying "Incomplete"

In SSRS I want to say anytime this field says "Incomplete" to change the string to "Pending"

This has to be done in SSRS.

Thanks!

Just use an expression:

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

Off the top of my head, you can do something like:

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