Skip to Content
0
Former Member
Nov 17, 2008 at 11:44 PM

Trying to identify empty " " records

17 Views

I have not used Crystal in a while and am stumped as to why my simple formula returns zero records when my record selection formula is written like this:

{Final_.Home Address PO Box} = "" and

{Final_.Mailing Address} = "Home" and

("Calendar - No Card" in {Final_.Categories} or

"Calendar (Home)" in {Final_.Categories} or

"Calendar (Golf)" in {Final_.Categories} or

"Family Card" in {Final_.Categories} or

"General Card" in {Final_.Categories})

The following formula (ie. when I omit the first line) gives me the expected results:

{Final_.Mailing Address} = "Home" and

("Calendar - No Card" in {Final_.Categories} or

"Calendar (Home)" in {Final_.Categories} or

"Calendar (Golf)" in {Final_.Categories} or

"Family Card" in {Final_.Categories} or

"General Card" in {Final_.Categories})

Any ideas? I have several more such conditions to insert but can't even get this one right!? What am I missing?

I am essentially trying to identify records where part of an address is missing so I am looking for fields with no data/ values in them.

PS> I'm sure there is a way to write the Final_.Categories selection more simply...any help on that would be most appreciated.