>No matter what I do I can't see the stored procedure in Crystal.You might want to try using the VFP OLEDB provider and access the data that way instead of through ODBC. I think the OLEDB provider is capable of enumerating stored procs, but I recall an earlier thread where someone described Crystal crashing while using OLEDB w/VFP. So, this may or may not work.
Laterness,
Jon
Jon Rosenbaum
Devcon Drummer