Symptom
- Error when refreshing some reports.
- Able to refresh the same report on other computers.
- When opening a report with saved data, it display: "The saved data will be discarded since one or more formulas failed to compile."
- When refreshing a report in Crystal Reports, it fails with the error: "UFL '<ufl name.dll>' that implements this function is missing."
-
Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
- SAP Crystal Reports 2011
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
- SAP Crystal Reports 2020
Reproducing the Issue
- In Crystal Reports, open a report.
- When refreshing the report, it fails with the error:
"UFL '<ufl name.dll>' that implements this function is missing."
Cause
- The error occurs if the report contains a formula that uses a function that is not part of Crystal Reports standard functions.
- Additional functions can be added to Crystal Reports using a User Function Library (UFL) created by third party developers.
- The UFL that implement the additional function, which name is displayed in the error message:
- Is Not on the computer where Crystal Reports is installed; or
- Is Not registered; or
- For Crystal Reports 2020: Is not compiled in 64bit, since Crystal Reports 2020 is a 64bit application.
Resolution
- Search for the User Function Library (UFL) on the computer where Crystal Reports is installed.
- If the UFL is not on the computer:
- Obtain the UFL file name showing in the error message from the third party developer.
Note: If the same report refresh successfully on another computer, search the UFL file name on the other computer.
- Copy the UFL file name to the following directory on the computer where Crystal Reports is installed:
- For Crystal Reports 2011, 2013, and 2016:
C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86
- For Crystal Reports 2020:
C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64
- Close, and re-open Crystal Reports.
- If the UFL is on the computer, then register the UFL:
Depending on how the Uuser Function Library was developed, it may need to be manually registered.
- In Microsoft Windows, right click the menu "Start", and select "Run"
- Type the command: regsvr32 <File Path\UFL File Name>
For example, if the UFL name and path are:
Path to the UFL : C:\Windows\My Folder
UFL File Name : u25myFunction.dll
Then the command to register the UFL will be: regsvr32 C:\Windows\My Folder\u25myFunction.dll - For Crystal Reports 2020, if the UFL is not compiled in 64bit:
- Contact the third party developers that created the User Function Library (UFL), and request them to compile the UFL in 64bit, except for Java UFL.
Keywords
CR, UFL , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Product
SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020