Report about empty fields

Hi there

How can I make a report that shows all “contacts” where the field “Emailadress” is “empty” ?

What character must I give to the Value Field to get this “empty” ?

I already tried * “” NULL %%%% and so on…

Here a screenshot of my issue:

Did anyone get back to you? I would can’t figure this out either. :S

As (a really awful) workaround you could:
. create a text field (you don’t need to add it to your layouts)
. create a logic hook or a custom scheduler or, possibly a workflow that checks the email field and, if empty writes EMPTY in the new field otherwise it writes FILLED
. create your report and ceck for EMPTY in the value of that field

I know that this is a horrible solution but it has worked for a few.