Hi Brenda

I know this isn't what you want to hear, but after messing with it a lot a number of years ago I came up with a Best Practices to Crystal and DBFS
- Buy gun
- put gun in mouth
- pull trigger

Randy Macatee wrote and add-on for VFE that got as far with it as I've seen anyone go and I even gave a presentation on it once but I can honestly say I never wanted to used Crystal with VFE after that. I would say either enjoy the cool new stuff in VFP 9 reporting or better yet, put your data in SQL server where it belongs and the you can point Crystal or Report Sharpshooter or whatever at it.

Sorry to be negative but my personal opinion is Crystal with VFP data is a painful painful experience.

>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