Returning null use

[Jazztpt]

Hi - Hope someone can assist. I am trying to return 'Members' who have no transactions. Basically a members card is swiped and then a transacation is processed which logs the transaction (usage) against the member. Rather than looking at transactions by member (the easy bit) I am trying to return details of Members who have no transactions (usage) for a given date range. This would be easy for me in Access but I am a Crystal beginner and struggling to find my feet.
Cheers
Jazztpt

 

[MisterMo]

do a left join between the members table and the usage

and of on the record selection formula add

isnull({usage.transaction}) = true



Mo

 

[lbass]

I think you would have to use a left join from the members table to the transaction table without using any criteria on the transaction table in the record selection formula. First group on {table.memberID} and then write a formula {@inrange} in the formula expert:

if isnull({transaction.ID}) or
not({transaction.date} in {?daterange}) then 0 else 1

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

sum({@inrange},{table.member}) = 0

-LB

 

[Jazztpt]

Thanks for the suggestions, I will give them a try and let you know how I get on.
Jazztpt