How do I replace field values using name.replace in the Report Designer if there are multiple substitutions? Adding another .replace() to the end doesn't work.
For example in the text box's properties under Design Field, I can do =FieldName.replace("Yes", "X")
That works fine, but I also need to replace the "No" values with a blank. I tried:
=FieldName.replace("Yes", "X").replace("No", "") and it returns "No". It would seem that it only takes the first replacement and ignores the rest. Is there another way to replace multiple string values in Report Designer?