Re: [libreoffice-users] LO Base Report of values of type BIT

2024-10-30 Thread Harvey Nimmo
On Wed, 2024-10-30 at 17:43 +0100, Robert Großkopf wrote: > Hi Harvey, > > > > Interestingly, exporting the 'virgin' report file as pdf retains > > the > > 'tick'/blank/minus symbols. > > You could also add UTF-8-Symbols. I do this in forms for Buttons. > Something like ✅ (U+2705)🛑 (U+1F6D1) … >

Re: [libreoffice-users] LO Base Report of values of type BIT

2024-10-30 Thread Robert Großkopf
Hi Harvey, Interestingly, exporting the 'virgin' report file as pdf retains the 'tick'/blank/minus symbols. You could also add UTF-8-Symbols. I do this in forms for Buttons. Something like ✅ (U+2705)🛑 (U+1F6D1) … Regards Robert -- Homepage: http://www.familiegrosskopf.de/robert -- To unsub

Re: [libreoffice-users] LO Base Report of values of type BIT

2024-10-30 Thread Java Joe
Per my experience the - signs are likely null value.  A boolean control cycles through True / False / Null unless you specifically disable null. On 10/30/24 11:25, Harvey Nimmo wrote: Interestingly, exporting the 'virgin' report file as pdf retains the 'tick'/blank/minus symbols. -- To unsubsc

Re: [libreoffice-users] LO Base Report of values of type BIT

2024-10-30 Thread Harvey Nimmo
On Wed, 2024-10-30 at 15:08 +0100, Robert Großkopf wrote: > Hi Harvey, > > do ist this way: > > IF([myBitField];"yes";"no") > > OR > > IF([myBitField];"☒";IF(ISBLANK([myBitField]);"-";"□")) > > Add this code in Data → Datafield. Write the name of the field inside > the brackets [] > > Regards

Re: [libreoffice-users] LO Base Report of values of type BIT

2024-10-30 Thread Robert Großkopf
Hi Harvey, do ist this way: IF([myBitField];"yes";"no") OR IF([myBitField];"☒";IF(ISBLANK([myBitField]);"-";"□")) Add this code in Data → Datafield. Write the name of the field inside the brackets [] Regards Robert -- Homepage: http://www.familiegrosskopf.de/robert -- To unsubscribe e-m

[libreoffice-users] LO Base Report of values of type BIT

2024-10-30 Thread Harvey Nimmo
I have a table in LO Base containing a number of fields of type Yes/No[BIT]. A value entered in such a field appears as a 'tick', (toggling between blank and 'tick') (By the way, 'minus' sign seems also to be alternatively equivalent to a blank) A report containing these tick values appears, as wa