0

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 ?

Swara
  • 15
  • 7
  • 1
    On the textbox in the report, create an expression `IIF(field.value = True, "Yes", "No")` – SS_DBA Jan 30 '20 at 20:41
  • I am using a lookup function to pull the data into the report field =LOOKUP(Fields!TXT.Value, Fields!TXT.Value, Fields!FUN.Value, "SPList") So , how do I format this field here Fields!FUN.Value – Swara Jan 30 '20 at 20:43
  • 2
    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 Jan 30 '20 at 21:11
  • supersimmer-44 , thank u – Swara Jan 30 '20 at 23:10
  • This should be added as an answer so it can be marked as accepted. It will stop people looking for an answer from ignoring this question as it looks unanswered and stop people wanting to answer questions, finding this because it's 'unanswered' – Alan Schofield Jan 31 '20 at 11:40

1 Answers1

0

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

Swara
  • 15
  • 7