crystal question

On my report I extract credit card data from two Oracle tables. Table one has the cardholder name and table two has the purchase. Report runs fine, except it doesn't show cardholders with no purchases. I need to show cardholder name and a label stating there were no purchases. I tried writing a formula using the count function, but thats not working...any suggestions?

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

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