Im trying to print out some values to a label based on whether it has a value or not, using the following:
Code: Select all
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, " ")}
I have tried the same with a switch as well, same issue.
Thanks