Report Designer - display boolean field as a checkbox

Hi @donnadeskins55 

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/

Hi Gabriel,

Thank you so much for the reply! I will give that a try!

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.

@donnadeskins55 yes that’s a good way too! If you want to use a plain text box you might want to consider using the Wingdings font that has plenty of characters that can be used a checkbox! 

https://en.wikipedia.org/wiki/Wingdings

I love it, thank you!