>When I Preview my report in Crystal Reports after doing
>COPY TO filename FOX2X (converts VFP 6 table to FoxPro 2.x table,
>the grand total count in my last column is correct.
>
>When I Preview my report in Crystal Reports using Crystal ODBC feature to access VFP 6 table without changing it to a FOX2X table,
>the total count in my last column is off by 1.
>
>I read on the Seagate support knowledgebase that I had to go into the MS ODBC Administrator and turn off "Fetch Data in Background." Is this true for the versions I am currently using? Have any of you had this problem using Crystal Reports 8 with VFP 6.0 tables where your sums/counts are incorrect?
>
>I would like to know. Thanks.
A couple of things to think about:
- Deleted records
- Are you using the same SQL SELECT statement in both cases?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer