The two tables must be Left Joined.
Your formula would like something like (Crystal Syntax)

If IsNull({Purchases.PurchaseId}) Then "No Purchases" Else ....