Joined: 29 May 2004
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:
|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.
Thanks to add [Solved] in your first post Title ( edit button ) if your issue has been fixed / resolved.