Does anyone know how to display a boolean field as a checkbox on a report?
Solved
Report Designer - display boolean field as a checkbox
Best answer by donnadeskins55
I actually found another way to accomplish this:
I added a text box and made the border on all sides a solid line. Then, in the value field I used this expression: =IIf([SSGNCR.InternalBool]=True, 'X', ''). This results in an “X” being put in the box if the boolean value is True.
+12Hi
There is no check box control in the Acumatica report designer. What you could do is use a picture box, with an image that looks like a check box, and then set the VisibleExpr property to your boolean field. This will ensure the checkbox is checked only when the field is TRUE. You can have another picture box with the inverse condition if you want to show an unchecked box when it’s FALSE.
There’s plenty of images you could use at https://thenounproject.com/term/checkbox/
I actually found another way to accomplish this:
I added a text box and made the border on all sides a solid line. Then, in the value field I used this expression: =IIf([SSGNCR.InternalBool]=True, 'X', ''). This results in an “X” being put in the box if the boolean value is True.
+12
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.