LimeReport Forum

General Category | Основное => Discussion | Обсуждение => Topic started by: wattswhat on December 15, 2022, 06:18:20 pm

Title: translating boolean values
Post by: wattswhat on December 15, 2022, 06:18:20 pm

How do I translate boolean values stored in the SQL Database as 0 and 1 to something else like "Yes" or "No" or "True" or "False"?

Title: Re: translating boolean values
Post by: Subst on December 20, 2022, 06:27:18 pm

HI!
By Script

$S{
  if ($D{table.field}==1)
     true;
  else
     false;
  }

and in your text element will be true/false

Title: Re: translating boolean values
Post by: wattswhat on December 20, 2022, 08:32:58 pm

Thanks!

Title: Re: translating boolean values
Post by: wattswhat on December 20, 2022, 09:02:29 pm

Is there documentation on Scripts?

Title: Re: translating boolean values
Post by: Subst on December 21, 2022, 08:26:22 am

What version of Qt you are using?

if 5.6 or later then LR using just JSengine (i.e. JS)

if 5.5 or early then LR using qtScript, thet also Ecma-262