Skip to main content
Solved

Report Designer - display boolean field as a checkbox

  • January 29, 2021
  • 5 replies
  • 920 views

Forum|alt.badge.img+1

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

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.

 

View original

Gabriel Michaud
Captain II
Forum|alt.badge.img+11

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/

 


Forum|alt.badge.img+1

Hi Gabriel,

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


Forum|alt.badge.img+1

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.

 


Gabriel Michaud
Captain II
Forum|alt.badge.img+11

@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


Forum|alt.badge.img+1

I love it, thank you!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings