Report Tags no NULL Entries

V5 Question
1

I’m trying to set up an export file to export customer data to csv.
I know how to do this via sql but I’m trying to learn how to use the report tags.

Here is the Tag
{REPORT ENTITY DETAILS:EC.Email:(ET=Customers)}

It returns a line for each entity even if the email field is blank.

Eg.

[email protected]

[email protected]
 

[email protected]
[email protected]

How can I remove these blank lines

2

Try this.

{REPORT ENTITY DETAILS:EC.Email:(ET=Customers) && (ECC.Email=@)}

ECC expression means “Entity Custom Field Contains” and It checks existence of @ symbol in Email field.