1208209 - 32 bit UFL Does Not Appear in "Additional Functions" List in Formula Editor

SAP Knowledge Base Article - Public

1208209 - 32 bit UFL Does Not Appear in "Additional Functions" List in Formula Editor

Symptom

A UFL was created using Microsft Visual Basic and an attempt is being made to use the UFL with 32-bit Crystal Reports.

When the UFL was created, it was specified to return data type "variant".

For Example:
Public Function GetFileDate(path As String) As Variant

The DLL has been installed in the correct BIN directory according to version, but the functions contained in the UFL do not appear under "Additional Functions" in the Formula Editor in Crystal Reports.

Cause

The DLL was created with type "variant" instead of a supported data type.

Resolution

During the creation of the User Function Library (UFL), the type must be declared as one of the data types that Crystal Reports (CR) supports. These are the supported data types:

Integer, Long, Single, Double, Currency, Date, Boolean, String.

When the return type is changed to one of the supported types, the UFL will then appear under "Additional Functions" in the Formula Editor.
 
See also Knowledge Base article C2001961, which concerns undeclared data types in UFLs.
 
The correct installation directory will be as follows:
For CR 10: C:\Program Files\Common Files\Crystal Reports\2.5\bin
For CR XI (R1): C:\Program Files\Common Files\Business Objects\3.0\bin
For CR XI (R2): C:\Program Files\Business Objects\Common\3.5\bin
For CR 2008: C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86
 

Keywords

UFL Datatypes Crystal Reports User Defined Functions Visual Basic Additional Functions List , c2001050 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V0 ; SAP Crystal Reports 10.0 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2