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»