More u2lcapw.dll fun

SOLVED

Recently upgraded my standalone workstation version of Crystal Reports to the 64 bit variety. Now I get the "u2lcapw.dll" error on all Sage 300 Crystal reports (2023 PU1). I've done all the usual copying of the u2* files from both c:\windows\crystal and C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86 to both the system32 and syswow64 folders. No dice. Anyone else using the 64 bit version of Crystal reports with the same issue? I might just go back to the 32 bit version.

Parents
  • +1
    verified answer

    u2lcapw.dll is a 32-bit Crystal Reports UFL (User Function Library), so it can't be used in Crystal 2020 (64-bit).

    Good chance your report is using the PwFormatDate() function to convert YYYYMMDD integer values into Date values.
    If you wish to stay with 64-bit Crystal, you can replace the function call with formula logic. For example:

    local numbervar YourNumberDate := 20231020;
    
    cDate(Val(ToText(YourNumberDate,0,'')[1 to 4]), 
          Val(ToText(YourNumberDate,0,'')[5 to 6]), 
          Val(ToText(YourNumberDate,0,'')[7 to 8]));

    Alternatively, there is at least one 3rd-party Crystal Reports UFL (with 32-bit as well as 64-bit versions) that provides such a function.
    Ken hamady maintains a listing of 3rd-party Crystal Reports UFLs here.  

Reply
  • +1
    verified answer

    u2lcapw.dll is a 32-bit Crystal Reports UFL (User Function Library), so it can't be used in Crystal 2020 (64-bit).

    Good chance your report is using the PwFormatDate() function to convert YYYYMMDD integer values into Date values.
    If you wish to stay with 64-bit Crystal, you can replace the function call with formula logic. For example:

    local numbervar YourNumberDate := 20231020;
    
    cDate(Val(ToText(YourNumberDate,0,'')[1 to 4]), 
          Val(ToText(YourNumberDate,0,'')[5 to 6]), 
          Val(ToText(YourNumberDate,0,'')[7 to 8]));

    Alternatively, there is at least one 3rd-party Crystal Reports UFL (with 32-bit as well as 64-bit versions) that provides such a function.
    Ken hamady maintains a listing of 3rd-party Crystal Reports UFLs here.  

Children