>Hi Jim,

I don't know the cause of your particular problem, but I wonder if you have thought about the possibility to copy the resultset to a FOX2X table and let Crystal Reports use this file directly, since Crystal Reports has native support for FOX2X tables.

Using ODBC can be troublesome (as you've have discovered) and be a lot slower than using FOX2x Tables.

Walter,



>
>I'm new to Crystal Reports and ODBC and am having trouble getting things to work properly.
>
>I can load CR, create a report, and preview the report data initially. If I click the refresh button I get two error messages.
>
>1. ODBC error: [Microsoft][ODBC Visual FoxPro Driver]File 'master.dbf' does not exist.
>
>I click the "OK" button and then this error.
>
>2. Error detected by database DLL.
>
>This happens only when I click the refresh button???? I'm always able to create the report initially, whether using data on my local machine or data on our server, just can't view refreshed data???
>
>My local machine's ODBC Data Source Administrator shows Visual FoxPro Database and Tables drivers in the "User DSN" tab under "User Data Sources"
>
>My pc is a windows 2000 computer.
>
>I really don't know anything yet about the ODBC, never had any experience, but I want to find out so I can use the CR in my application.
>
>I want to create reports on my local pc for my users to use in my application which resides on our server.
>
>Any help would really be appreciated.
>
>TIA
>
>Jim Harvey
>jharvey@netrax.net