SAP Knowledge Base Article - Public

2814503 - Error: "UFL '<ufl name.dll>' that implement this function is missing." when opening a report in Crystal Reports

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

  1. In Crystal Reports, open a report. 
        
  2. When refreshing the report, it fails with the error: 
      
    "UFL '<ufl name.dll>' that implements this function is missing."
         
        
    UFL Error.png

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:
             
      1. 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. 
               
           
      2. 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
           
                   
                       
      3. 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.
            
      1. In Microsoft Windows, right click the menu "Start", and select "Run"
            
      2. Type the command: 
          
        • For Crystal Reports 2011, 2013, and 2016:
          regsvr32 <File Path\UFL File Name>
            
        • For Crystal Reports 2020:
          regsvr64 <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.

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