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!
+1
A:
Off the top of my head, you can do something like:
=Replace(Fields!thisItem.Value, "Incomplete","Pending")
Alison
2010-08-25 21:50:32
Um, no. It is syntactically exactly what works. Anytime the word "Incomplete" appears in the field, it will be changed to "Pending".
Alison
2010-08-25 22:28:42
@Alison - sorry, my bad. Comment retracted.
slugster
2010-08-26 01:15:51
Actually, you are right in suggesting that there is a better way to implement it. My code will change every single instance of the word "Incomplete". Decker97's code will first check to see if "Incomplete" is the only word in the field and then update. It really depends on what the OP is looking for.
Alison
2010-08-26 01:42:10
+6
A:
Just use an expression:
=iif(Fields!Field1.Value="Incomplete", "Pending", Fields!Field1.Value)
Decker97
2010-08-25 21:51:24