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.