Selecting Data only if all lines of data do not have a specific 1

[kime1974]

Crystal v8.5

I am trying to pull all subscribers in our enrollment database who do not have a particular coverage type (i.e. Life Insurance). The problem I am having is that each subscriber can have more than one line of data in the system (i.e. they have Medical, Dental, etc.).

When I try to extract the subscribers who do not have Life Insurance, it reads each line of data and evaluates them individually and returns data if Medical doesn't equal Life, Dental doesn't equal Life, etc..

Any thoughts on how to evaluate a subscriber with a unique ID number (in Member Table) and link to Plan Type (in Enrollment Table)?

Thanks!

 

[lbass]

Insert a group on subscriber and then create a formula {@Life}:

if {table.insurance} = "Life" then 1

Then go to report->selection formula->GROUP and enter:

sum({@life},{table.subscriber}) = 0

-LB

 

[kime1974]

Thanks lbass! I was doing something along those lines, but not at the group level. Thanks again!