Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP 6, ODBC, Crystal Reports 8 = sum and count problem
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
VFP 6, ODBC, Crystal Reports 8 = sum and count problem
Miscellaneous
Thread ID:
00461541
Message ID:
00461541
Views:
90
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.
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site: www.stephenkramer.com
Would you believe Far Side Lite?
More than 270 original cartoons.
Next
Reply
Map
View

Click here to load this message in the networking platform