Creating reports and dashboards | Stimulsoft community forum

Posted: **Fri Aug 04, 2017 12:02 am**

Hi,

Im trying to print out some values to a label based on whether it has a value or not, using the following:

JobID:
----------------------------------------------
{IIF(Length(UnservicedJobs1.jobid) > 0, UnservicedJobs1.jobid, " ")}
{IIF(Length(UnservicedJobs2.jobid) > 0, UnservicedJobs2.jobid, " ")}
{IIF(Length(UnservicedJobs3.jobid) > 0, UnservicedJobs3.jobid, " ")}
{IIF(Length(UnservicedJobs4.jobid) > 0, UnservicedJobs4.jobid, " ")}
{IIF(Length(UnservicedJobs5.jobid) > 0, UnservicedJobs5.jobid, " ")}

however if it evaluates to false, it prints a 0 not a blank space.

I have tried the same with a switch as well, same issue.

Thanks

Posted: **Fri Aug 04, 2017 1:58 pm**

Hello,

Please try to set the HideZeros property for the Text component.

Thank you.

Creating reports and dashboards | Stimulsoft community forum

IIF return null if not true

IIF return null if not true

Re: IIF return null if not true