We are running Accpac Pro under VFP 8.0 with a SQL Server 2000 back-end. In some instances, and not always consistenetly, reports are missing a few records of data. Typically the first half-dozen records on the report.

If a report is previewed it looks just fine, all the data is there. If we copy the data from the SQL data to a temporary VFP table then everything works OK, but when printing directly from a SQL data source we get the problem.

We do not embed a Data Environment in the report, and we do not use aliases.

This is happening over 2 sites, and seems particular to SQL as both sites have the SQL back-end. None of our clients using VFP on the back-end are getting the problem.

I have researched UT for the same problem and have found several threads discussing similar problems, but nobody has ever come up wth solution...

Thanks
Chris Palmer