Just installed Crystal Report 11. Want to use a VFP table as a data source in the Crystal Report designer. I have read that there are three options:

1) Native access. I assume that this means to select "Create New Connection", "Database Files", then select the .dbf file. (I did COPY TO ... TYPE FOX2X to create a FOX2X table). The .dbf File Type says it is a xBase table. And when I try to Open the .dbf I get a "Failed to Load Database Information", then "Unknown Database Connector Error".

2) ODBC. How do I use this screen? In odbcad32.exe I created a User DSN that paths to a specific folder that has .dbf files in it. But how do I use this the Crystal Report Data Source Select to be more generic - to open any .dbf table without having to go to odbcad32.exe first? Visual Foxpro tables is a Data Source Name. Just do not have any DSN in my C:\Program Files\Common Files\ODBC\Data Sources folder.

3) OLE DB. I got this to work.

Now ... does anyone have any sample code to use a report from within a VFP application. Use a simple example to get me started.

Thanks

Brenda