Tuesday, April 6, 2021

How to integrate Jasper Report in Linux

cd /opt/oracle/apex

copy jri-2.7.0-jasper-6.16.0.zip to /opt/oracle/apex ---- By SSH Secure file transfer

Download : https://github.com/daust/JasperReportsIntegration/releases

unzip jri-2.7.0-jasper-6.16.0.zip

mv jri-2.7.0-jasper-6.16.0 jri


cd /opt/oracle/apex/jri

mkdir conf

mkdir logs

mkdir reports


cd /opt/oracle/apex/jri/bin


chmod +x setConfigDir.sh


cd /opt/oracle/apex


mkdir rep


cd /opt/oracle/apex/jri/bin


chmod +x setConfigDir.sh


chmod +x /opt/oracle/apex/jri


./setConfigDir.sh /opt/oracle/apex/jri/webapp/jri.war /opt/oracle/apex/jri


cd /opt/oracle/apex/jri/conf


192.168.1.1


vi application.properties

---- Change IP Address, Port, DB, Username and password.

cp /opt/oracle/apex/jri/webapp/jri.war /usr/local/tomcat/webapps/


cd /usr/local/tomcat/bin


./shutdown.sh 

./startup.sh


Copy Reports to : (.jasper)

/opt/oracle/apex/jri/reports

Javascript :

var report_server = "http://localhost:8080/jri/report?";

var report_name = "dept";
var report_format = "pdf";
var data_source = "default";

var run_report=""+report_server+"&_repName="+report_name+"&_repFormat="+report_format+"&_dataSource="+data_source+"";

window.open(run_report);

Javascript with parameter :

var report_server = "http://localhost:8080/jri/report?";

var report_name = "dept_param";
var report_format = "pdf";
var data_source = "default";

var ap_1 = $v("P3_DEPT");
var rp_1 = "&P_DEPT";

var param = ""+rp_1+"="+ap_1+"";

var report=""+report_server+"&_repName="+report_name+"&_repFormat="+report_format+"&_dataSource="+data_source+"";

var run_report = ""+report+""+param+"";

window.open(run_report);

0 comments:

Post a Comment