I am using MS Access 2003 to preprocess tables from a FoxPro Application before using Crystal Reports for custom reports. I am getting inconsistent and erratic results - the data seems to always be right in my office, but when the client is running it in their office, sometimes it's right...
I'm using CR XI, with an ODBC connection to FoxPro. Its a File DSN with Fetch Data in Background turned off. OS is XP Pro on a machine with 1 GB of RAM.
The table structures are such that to collect the data I need, I have strung together 8 SQL statements with UNION ALL and dropped the data...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.