[libreoffice-users] Re: Changing Base report boolean representation

On 23/10/2013 03:59, Girvin Herr wrote:

Hi Girvin,


> Linux LO 3.6.7.2.
> I am working on my MySQL Base reports with Report Builder.  The default
> output of a boolean value is TRUE/FALSE.  Is there a way to change this
> to a check mark or X for TRUE and blank for FALSE?
> All the FALSEs clutter up my reports, making the TRUEs hard to see in
> the forest.  The forms use a check mark widget, which would be ideal.

A partial workaround, because I haven't found a way to insert unicode
characters into a number formatted field control :

In Report Edit Mode, bring up the Properties of the control you want to
change.

On the first tab "General", set Formatting to Number - General.
On your Data tab :
Data Field Type : Field or Formula

Data Field : select your boolean field

When you now save and run the report, you will get '1' and '0' instead
of 'True' and 'False'


Alex




-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted