Suppress Email or Blank Field 2

[TymArtist]

I'm trying to create a report that shows a record of all the customers in our database that do NOT have an email address on file.

My method was to try and use the select expert so if customer.email contains "N/A" or "" (blank) then it will show. However, it doesn't seem to like the "" command, and won't display the records that are blank.

My possible 2 solutions, neither of which I can figure out how to formulate:
1. "if this field contains the character @ then suppress the record"
2. "if there is no email address then show the record"

Can anyone help me out here?

 

[BobSuruncle]

You could try this:
IsNull({Customer.email})
or {Customer.email} = ""
or {Customer.email} = "N/A"


Bob Suruncle

 

[synapsevampire]

Saying "However, it doesn't seem to like the "" command, and won't display the records that are blank" doesn't define what happened, state whether it had an error, or why you think that Crystal isn't fond of it.

To make sure that you see everything that does NOT contain a valid email, I'd go with your <> contain @ theory, seems like a good idea:

isnull({table.email})
or
not({table.email} like "*@*")

That way you might pick up some invalid entries as well.

-k