Solved

Report Designer - display boolean field as a checkbox

  • 29 January 2021
  • 5 replies
  • 74 views

Does anyone know how to display a boolean field as a checkbox on a report?

icon

Best answer by donnadeskins55 2 February 2021, 19:44

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.

 

View original

5 replies

Userlevel 5
Badge +3

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.

 

Userlevel 5
Badge +3

@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!

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2020  Acumatica, Inc. All rights reserved