More u2lcapw.dll fun

Question

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.

Jay Converse Acumen · Accepted Answer

Do not use the 64 bit version.

ixm7 · 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 .

Sage 300

More u2lcapw.dll fun

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING