>I've defined a UDF as a method in a form which will run a report, the UDF will be called from the report field expression, it can work in preview(REPORT FORM
PREVIEW) but couldn't work when send to printer(REPORT FORM TO PRINTER), instead of printing the correct figure, it print the format string.(eg. 9,999,999.99).
>
>If I create a variable in report writer, the expression of the variable is the UDF, when I used the variable with some calculation, an error message "Data type miss match" will be given when running the report.
>
>Please help.
>Any body can help, thanks in advance.
This may be a personal preference, but since reports are not truly OO, I put any UDFs that are called by reports in a separate proc file which I set prior to calling any report and release afterwards. If it's a function that you need while the form is active, you could issue a SET PROC in the load or init event and a RELE PROC in the the release or unload event.
Just my idea. HTH
Matt McDonnell
...building a better mousetrap with moldy cheese...