Hi AKhan,

I am using ODBC and connecting to a SQL backend. The SQL query is actually taking place from within the Crystal Report, I am not doing it from VFP.

Is there a way to check for the records returned from within Crystal?

Thanks,

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