Test for NULL or Empty Custom Field in REPORT

[pauln]

Trying some funky Ternary to see if I can omit lines that way but epic FAIL!

Just returns EC.Orders but does only print 3 lines?

[Ternary Test A:1,1]
{REPORT ENTITY DETAILS:EC.Orders:(ET=Suppliers)} != '' ? 'Yes' : 'No'

Prints nothing except the Header.

[Ternary Test B:1,1]
[=('{REPORT ENTITY DETAILS:EC.Orders:(ET=Suppliers)}' == '' ? 'No' : 'Yes')]

Ok Found something where @emre is using a Custom Field in the EXPRESSION!

@emre

You’ll notice I have two reports. First part of the report is what you’ll need. You’ll notice customer birthday appears as local date time format.

[Customer BirthDay:1,1]
Name|Date of Birth
{REPORT ENTITY DETAILS:
E.Name,
EC.DOB
:(ET=Customers)
&& DateTime.Parse(Entity.GetCustomData(“DOB”)).Day==DateTime.Now.Day
&& DateTime.Parse(Entity.GetCustomData(“DOB”)).Month==DateTime.Now.Month}

Ummm - suggestions welcome in the mean time…

Ok stumped this should work? Wonder what version is required!

[Another Test C:1,1]
{REPORT ENTITY DETAILS:E.Name,EC.Orders:(ET=Suppliers) && Entity.GetCustomData("Orders")!=''}