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