Print if not empty? »

[darktorres]

Hi, is there some way to only print text from datasource if it´s not empty?

[Arin Alex]

Hi, What do you mean only print text ?

[darktorres]

In the databand is there some way to show a secondary value if it´s not null? Like: $D{db.price} + if(!$D{db.discount}.empty) $D{db.discount}

[Arin Alex]

Code: [Select]

$S{if ($D{db.price}!="") $D{db.price} + " "+$D{db.discount}; else ""}

[darktorres]

Thanks!

[pasnox]

Similary to this: empty fields, or not existing field in the actual query: how can we suppress the warnings ?
We have reports used by many customers, and sometimes some fields does not exists for one.
In this case we want to suppress the warning message but did not find any solution ?

Opened: https://github.com/fralx/LimeReport/issues/38

[Subst]

try to use external variables from your program. That determine need or needless printing

[Arin Alex]

I have added "Suppress absent fields and variables warning" parameter to report settings

[pasnox]

Thanks!

Now the next issue
We can now quiet warnings for missing fields, but I did not find a way to give fallback values.
When a field is missing, it seems the custom script exit instead of simply return null value for the queried field:

Code: [Select]

$S{
    "$D{Marcel.pagnol}" === "" ? "$V{Marcel.pagnol}" : "$D{Marcel.pagnol}"
}
The data source Marcel and the field pagnol does not exists, though I have declared a custom variable Marcel.pagnol.

What I want is to fallback to my custom variable if the data source field does not exists.
Actually this throw: SyntaxError: Parse error
Any ideas ?

EDIT: In the end it does just works! I was missing the quotes around the variables.