Converting Check Box data (1’s and 0’s) into Yes and No

If you add a check box to your form, when you add this data to a report, the results will default as 1’s and 0’s, in order to change these to Yes’s and No’s, follow the steps below:

• Add the checkbox data field onto the report and right click the check box field and from the list that appears select Expression
•  The expression pop up window should appear.
• Within the Set expression for: Value part of the window you will find the name of the field you have just added, an example is shown below:

    =Fields!Checkbox.Value

• You will need to remember this name as we will replace it with a new expression to convert the data but will need this name to attach it to this file
• Delete the expression within the expression pop up window and insert =iif(Fields!Checkbox.value.ToString().Equals("1"),"Yes","No")

• Highlight the Fields!Checkbox.value part of the expression and paste the name of the checkbox field you previously deleted.
• Click OK
• The cell should now be populated by «Expr»