>We have several functions in Visual FoxPro which are used to perform processing on a character string. the functions accept the string as a parameter, and return another string. This return string is then used in a formula which appears on the report.
>
>We are attempting to duplicate this report in Crystal Reports, running as a stand-alone report connected to the FoxPro database via ODBC. However, to the best of our knowledge, there is no way that Crystal Reports can call a FoxPro function. Somehow, the functions are going to have to be recreated as a .DLL or an ActiveX object which Crystal Reports can reference. I have no experience in writing FoxPro .DLLs, and would be reluctant to try. Besides, I don't think this would be acceptable to Crystal Reports.
>
>According to the Crystal Reports help, DLLs, a.k.a. UFLs, must be written in C. We have C++ as part of Visual Studio, but even if this is an acceptable version of C, we have no practical experience in it, so writing the DLL in C++ is not an option.
>
>Could the DLL / UFL be written in Visual Basic? I know that Crystal Reports comes with Visual Basic, so I would (pardon the word) ASSUME that DLLs created in Visual Basic would work with Crystal Reports, with a minimal amount of fuss.
>
>I have already posed this question to Seagate Crystal Reports Tech Support, but I don't know how Fox-savvy they are. I'm hoping that someone with a more Fox-oriented mindset might be able to help. As I stated, the ideal solution would be to call the FoxPro function from Crystal Reports, but I don't see that happening. The most preferred solution would be to rewrite the functions in VB and compile them as a DLL. Anything beyond that, and we are getting into a very difficult and time-consuming solution for us. We are fairly new to Crystal Reports, and have never tried to write a Crystal Reports function, so some of the steps which would be obvious to a Crystal Reports guru are not so obvious to us.
>
>TIA,
>
>Bill
Bill,
Since you can't get Crystal Report to execute a function for you, why not do all the work on the VFP side and give Crystal Report a finished master cursor with all the results in it?
José
