Yes/No check box in report

[SusanMontauk]

I love the way yes/no formatted columns appear in tables and queries. Now I would like to see that in a report. Instead, I get true/false. I am trying to put out a simple attendance form, and that doesn't look so good.

[F3K Total]

Hi,
if you use the Reportbuilder,
try this formula on the data tab of the boolean field

Code: Select all

IF([boolean field];"☑";"☐")

Works for me with the english Version of LO, but not with the german version of AOO 3.4.1, maybe with yours?
R
Edit: I found out that the Oracle Report builder doesn't do that, it works only with the report builder of LibreOffice, which can't be downloaded, 'cause it's included in the LO package.

[Nocton]

Make a query with a field specified as

Code: Select all

CASEWHEN( [MyField], 'Yes', 'No' )

where MyField is the name of your boolean filed in your table. Now just use that query as the data source for your report.

Regards,
Nocton