Skip to Content
2

How to make a Java UFL available in Crystal Reports Designer 2016

Apr 05, 2017 at 09:42 AM

100

avatar image

I try to make Java UFL library available in Crystal Reports 2016 on Windows 10.

I tried following tutorials without success.

https://apps.support.sap.com/sap/support/knowledge/public/en/1803967

https://archive.sap.com/discussions/message/6637161#6637161

https://archive.sap.com/discussions/thread/3256500

ftp://81.184.0.178.static.user.ono.com/Instalaciones/Crystal%20Reports/Crystal%20Reports%2011/Docs/JavaReportingComponent_docs/reference/JavaUFL5.html

I managed to do it on Crystal Reports 2013 on Windows 7 and it works but I cannot make UFL Java available on Crystal Reports 2016.

It is my registry values at HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports

JavaUFLLogging=C:\UFLlogging
JREPath=C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\sapjvm\jre\bin\server\jvm.dll

I also set JREPath to Java which I installed myself.

My classpath environment variable:

CLASSPATH=C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports\java\lib\external\commons-collections-3.2.2.jar;C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports\java\lib\external\commons-configuration-1.2.jar;C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports\java\lib\external\commons-lang-2.1.jar;C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports\java\lib\external\commons-logging.jar;C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports\java\lib\external\icu4j.jar;C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\lib\external\log4j.jar;C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports\java\lib\CrystalFormulas.jar;C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports\java\lib\CrystalReportingCommon.jar;C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports\java\lib\u211java.jar;C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports\java\lib\JUFLBar.jar;C:\Users\admin\Desktop\jar\com.azalea.ufl.barcode.1.0.jar;C:\Users\admin\Desktop\jar\CrystalReportsRuntime.jar;C:\Users\admin\Desktop\jar\cvom.jar;C:\Users\admin\Desktop\jar\jai_imageio.jar;C:\Users\admin\Desktop\jar\JDBInterface.jar;C:\Users\admin\Desktop\jar\keycodeDecoder.jar;C:\Users\admin\Desktop\jar\logging.jar;C:\Users\admin\Desktop\jar\pfjgraphics.jar;C:\Users\admin\Desktop\jar\xpp3.jar

C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports\java\lib\JUFLBar.jar is my Java UFL. I added also additional jar but I think that they are not necessary.

My CRConfig.xml file:

<ExternalFunctionLibraryClassNames> 
<classname>mypackage.MyUFLClass</classname>
<classname> </classname>
</ExternalFunctionLibraryClassNames>... 

<Javaserver-configuration> 
<DataDriverCommon>
<JavaDir32>C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\sapjvm\bin</JavaDir32>
<JavaDir64>C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64\sapjvm\bin</JavaDir64>
<Classpath>C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports\java\lib\external\commons-collections-3.2.2.jar;C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports\java\lib\external\commons-configuration-1.2.jar;C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports\java\lib\external\commons-lang-2.1.jar;C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports\java\lib\external\commons-logging.jar;C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports\java\lib\external\icu4j.jar;C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\lib\external\log4j.jar;C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports\java\lib\CrystalFormulas.jar;C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports\java\lib\CrystalReportingCommon.jar;C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports\java\lib\u211java.jar;C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports\java\lib\JUFLBar.jar;C:\Users\admin\Desktop\jar\com.azalea.ufl.barcode.1.0.jar;C:\Users\admin\Desktop\jar\CrystalReportsRuntime.jar;C:\Users\admin\Desktop\jar\cvom.jar;C:\Users\admin\Desktop\jar\jai_imageio.jar;C:\Users\admin\Desktop\jar\JDBInterface.jar;C:\Users\admin\Desktop\jar\keycodeDecoder.jar;C:\Users\admin\Desktop\jar\logging.jar;C:\Users\admin\Desktop\jar\pfjgraphics.jar;C:\Users\admin\Desktop\jar\xpp3.jar;C:\CrystalJDBC\ojdbc8.jar;C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java/lib/crlovmanifest.jar;C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java/lib/CRLOVExternal.jar;C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java/lib/CRDBJDBCServer.jar;C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java/lib/CRDBXMLServer.jar;C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java/lib/CRDBJavaBeansServer.jar;C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java/lib/external/log4j.jar;C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java/lib/CRDBWicServer.jar;C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java/lib/external/CRDBWicExternal.jar;C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java/lib/external/CRDBXMLExternal.jar;${CLASSPATH}</Classpath>

...

I also set JavaDir32 to Java which I installed myself. I added all jars from classpath environment variable to classpath section in CRConfig.xml.

My JAVA_HOME:

JAVA_HOME=C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\sapjvm

I also set JAVA_HOME to JAva which I installed myself.

I set Java UFL's Only in Crystal Reports. I restarted Crystal Reports, I also restarted PC and my Java UFL libarary is still not available in "Additional functions" in Crystal Reports.

How to make a Java UFL available in Crystal Reports Designer 2016?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers