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

Find out how to change the raw data from checkboxes (1's and o's) to the values 'Yes' and 'No' on your report.

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:


  • 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»