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.
+11There 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/
Gabriel Michaud Founder @ Velixo, Excel-based reporting for Acumatica
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.
+11
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.