Thanks

I guess this is ok. My application only has a few hundred records on any given report.

>Hi Robert
>
>>I have looked at the many excellent threads on using Crystal Reports with VFP6. Most people suggest using Fox2x tables. And I like this because I do not want to install ODBC when the users install my application. Or at least I think I do not want to install ODBC. But one question I have is, what is the process for creating the Fox2x table. Do you:
>>1. Select from VFP6 table into a cursor, changing the long names to short names.
>>2. Copy the cursor to a Fox2x table.
>>3. Run CR report.
>
>Yep, in general this is how I do it. In particular cases (Large report files) I might skip the SQL-Query and gather the data via another way and store it in the FOx2.x table directly.
>
>
>Walter,