Jasper¶
Table of Contents
JasperReportsIntegration¶
The information below pertains to the deployment of JasperReportsIntegration in JRI Publisher. For full documentation of JasperReportsIntegration, please see http://www.opal-consulting.de/downloads/free_tools/JasperReportsIntegration/
File Locations¶
On installation, the JRI files are saved to:
/home/tomcat/apache-tomcat-v/jasper_reports
Here, you will find the following:
/home/tomcat/apache-tomcat-v/jasper_reports/conf
/home/tomcat/apache-tomcat-v/jasper_reports/schedules
/home/tomcat/apache-tomcat-v/jasper_reports/reports
/home/tomcat/apache-tomcat-v/jasper_reports/logs
** reports ** contains your Jasper report files.
** conf ** contains the application.properties file
** schedules ** contains the .sh files for the Scheduler
Gen Script¶
The Report Scheduler script is located under /etc/init.d/gen_jri_report.sh and can be customized to suit and extend your requirements.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 | #!/bin/bash -e source /etc/environment JRI_HOME="${CATALINA_HOME}/jasper_reports/" #source the report environment source "${JRI_HOME}/schedules/${1}_env.sh" DONT_MAIL="${2}" #set who is sending the mail export EMAIL='root@localhost' REPORT_FOLDER=$(dirname ${REP_ID}) #encode the / in report id REP_ID=$(echo "${REP_ID}" | sed 's/\//%2F/g') if [ "${OPT_PARAMS}" ]; then OPT_PARAMS="&${OPT_PARAMS}" fi URL="http://localhost:8080/JasperReportsIntegration/report?_repName=${REP_ID}&_repFormat=${REP_FORMAT}& _dataSource=${REP_DATASOURCE}&_outFilename=${REP_FILE}${OPT_PARAMS}" TSTAMP=$(date '+%Y%m%d_%H%M%S') REP_FILEPATH="${JRI_HOME}/reports/${REPORT_FOLDER}/${TSTAMP}_${REP_FILE}" wget -O"${REP_FILEPATH}" "${URL}" if [ $? -ne 0 ]; then rm -f "${REP_FILEPATH}" fi |
JRI Module Files¶
On installation, the JRI Module files are saved to:
/usr/libexec/webmin/jri_publisher (CentOS)
/usr/share/webmin/jri_publisher (Ubuntu)
The JRI Module configuration files are located at /etc/webmin/jri_publisher:
/etc/webmin/jri_publisher/config
/etc/webmin/jri_publisher/openjdk_version_cache
/etc/webmin/jri_publisher/oracle_version_cache
reports contains your Jasper report files.
conf contains the application.properties file
schedules contains the .sh files for the Scheduler
Schedule Files¶
Each schedule creates a numeric file under:
/home/tomcat/apache-tomcat-version/jasper_reports/schedules
The file has the following structure:
1 2 3 4 5 6 7 8 9 | REP_FORMAT=pdf REP_ID=NewReports/StateInfo OPT_PARAMS="StateID=51" REP_DATASOURCE="Demo DS" EMAIL_SUBJ="State Report" REP_FILE=State-Info.pdf EMAIL_BODY="Please find the State Reports attached." SCH_ID=12 RECP_EMAIL=user@company.com |
The above parameters are passed to the Jasper url as well as to MUTT for email delivery.
MUTT Parameters¶
JRI Publisher uses MUTT in conjuction with Postfix to deliver reports via email.
The final input has the form:
./etc/init.d/gen_jri_report.sh schedules.{1}
Where schedules.{1} is passed to gen_jri_report.sh