General information
Category:
Reports & Report designer
Title:
Missing SQL data on reports
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only