One way to do that is when you execute your sql query check for _tally, if _tally>0 then display the report form or else display the messagebox windows for no records found.

HTH

>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?