>David,
>
>I used to use FOX2X to allow Crystal to handle my VPF tables, but I found that the ActiveX control works OK if I set up ODBC VFP tables using ODBC Administrator to point to the location of my VFP tables/DBs.
>
>It was a pain always having to copy my VPF 6.0 tables to a FOX2X format prior to being able to use them.

You don't have to copy all of them. Run a .prg that runs the proper query and creates one or two Fox2X tables that contain just the data needed for the report.

>I wish Crystal read VFP tables the same way it reads FOX2X tables. It would sure make life easier.

Nice thought, but it won't happen.

>
>Things get wild and crazy when you have to use ODBC Adminstrator and make multiple DSNs, one per report that uses a VFP table/DB found in a different directory/path. I am still tackling that portion. I understand from Bernhart Milcent, fellow UTer, that I can also pass the DSN parameters to Crystal from VFP similar to passing date parameters. He showed me samples how to do it.

You can pass everything you need as parameters. It would also be easier and faster to use OLEDB.

>
>You're right though, Crystal is heavy on the VB and not much on the VFP. Even when you call tech support or look at their website, you find that out. But if you can read VB, then you can tranlate what you need into VFP pretty much.

How is this any different from any generic third party control?

>
>All the best.