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?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer