01. Place the 3 (core-1.7.jar, javase-1.7.jar, qrgen-1.2.jar ) jar files and 1 (qrcode.class)class files in the F:\Middleware\product\reports\jlib\ folder
02. Edit the REPORTS_CLASSPATH as below
Regedit >
( javase-1.7.jar,core-1.7.jar,qrgen-1.2.jar )
F:\Middleware\product\jlib\core-1.7.jar;F:\Middleware\product\reports\jlib\javase-1.7.jar;F:\Middleware\product\reports\jlib\qrgen-1.2.jar;F:\Middleware\product\reports\jlib
REPORTS_PATH
F:\Middleware\product\reports\jlib\rwbuilder.jar;F:\Middleware\product\reports\jlib\rwrun.jar;F:\Middleware\product\jlib\zrclient.jar;F:\Middleware\product\jlib\oraclebarcode.jar;F:\Middleware\product\jlib\core-1.7.jar;F:\Middleware\product\reports\jlib\javase-1.7.jar;F:\Middleware\product\reports\jlib\qrgen-1.2.jar;F:\Middleware\product\reports\jlib
03. Modify 2 Lines the Reports Server configuration file (rwserver.conf) in order to add/modify the classPath Reports engine attribute :
<engine minEngine="1" maxIdle="30" maxEngine="1" id="rwEng" engLife="50" class="oracle.reports.engine.EngineImpl" classPath="F:\Middleware\product\reports\jlib\rwbuilder.jar;F:\Middleware\product\reports\jlib\rwrun.jar;F:\Middleware\product\jlib\zrclient.jar;F:\Middleware\product\jlib\oraclebarcode.jar;F:\Middleware\product\jlib\core-1.7.jar;F:\Middleware\product\reports\jlib\javase-1.7.jar;F:\Middleware\product\reports\jlib\qrgen-1.2.jar;F:\Middleware\product\reports\jlib">
For building QR Code report:
1. import java class file 'qrcode.class' in report.
2. create this funtion:
function CF_1Formula return Char is
image_file_name VARCHAR2(1000);
begin
image_file_name := SRW.CREATE_TEMPORARY_FILENAME ;
qrcode.generate (:qrcode , image_file_name);
return(image_file_name);
end;
...............
https://mohammadfawzy.wordpress.com/2016/02/16/how-to-generate-2d-barcode-qr-code-in-oracle-reports-doc-id-1678110-1/ for Oracle Report
https://vdocuments.mx/tutorial-qr-code-in-report-builder-using-paper-layout-a-tutorial-qr-code-in.html for EBS
No comments:
Post a Comment