Presenting Values from Checkboxes in a Report

1

Is there a method / customfunction that set the display values for checkboxes to Yes/No instead of True/False?
I have several custom checkboxes and have tried different methods (yes I’ve read the PDF) to print them in columns in a report.

e.g.
{tc}.{f}=0 ? No : Yes
({tc}.{f}=0 ? No : Yes)
{tc}.{f}==0 ? No : Yes

Any help would be appreciated.

Ultimately all I want is to print Yes if the checkbox is tricked and leave blank if unticked.

2

if you want to do this on sql you could use custom function like

if({tc}.{f}, 'Yes', 'No')

This is assuming you are using MySQL.