Hi Craig,

Report Alerts may be the answer if there is a way to determine if you get any records at all. I tried creating an alert on a field, but it did not work -- I think because there were no records to evaluate.

Is there some property that I can reference that will tell me if or how many records were returned from the query?

Thanks,

TFISHER



>You might want to see if Report Alerts will help you.
>
>>Hello,
>>
>>I am using VFP8 with SQL as a backend. I am calling a report viewer for Crystal 9 from within VFP.
>>
>>I have several reports and call each report from a button on a form. Some reports are for adults and others are for juveniles.
>>
>>At times, there are no juvenile records on which to report.
>>
>>When there are no juvenile records, is there a messagebox from within Crystal 9, that will come up and advise there are no records to view?