How to change the boolean value on the report to display as yes / no instead of true /false

Question

In SSRS , the boolean field from a sharepoint list is being displayed as true or False , I would liek that to be displayed as Yes or NO in the field. How do I do this ?

Answer 1

encapsulate your expression with an IIF. For example =IIF(LOOKUP(Fields!TXT.Value, Fields!TXT.Value, Fields!FUN.Value, "SPList") = True , "Yes" , "No") – SuperSimmer 44 21 hours ago