Sliderule
Super User
Joined: 29 May 2004
Posts: 2474
Location: 3rd Rock From The Sun
|
 Posted: Tue Feb 21, 2012 8:55 am Post subject: Re: yes /no box in reports |
 |
|
| johnfran25 wrote: | I have gotten the check box in my tables, queries and forms but can not get it in reports.
The report area shows true or false |
That is correct, the "check boxes" displayed within OpenOffice Base . . . for the table or query . . . is just the way it shows on the screen.
Per your description, if it were me . . . I would use a Query . . . to conditionally . . . output a few text characters to 'mock-up' the display with text characters as you want.
For example, if the table field is named "MyBooleanField" ( change this to the name of the field in your table  ) . . . in the Query, on the Field line in the GUI ( Graphic User Interface ) . . . I would use:
| Code: | | CASE WHEN "MyBooleanField" = TRUE THEN '[X]' WHEN "MyBooleanField" = FALSE THEN '[ ]' ELSE '[?]' END |
Explanation: The above, will handle the conditions for a TRUE value ( '[X]' ), for a FALSE value ( '[ ]' ), and, for a NULL value ( '[?]' ) . . . ( undefined or neither TRUE nor FALSE ). Of course, you can change the display characters between the single quotes to your choice, this is just an example.
I hope it helps, please be sure to let me / us know.
Sliderule
Thanks to add [Solved] in your first post Title ( edit button ) if your issue has been fixed / resolved. |
|
