Skip to main content

Jasper report installation

 

Jasper report server configuration

Installation :

 

 

 

 

 

 

 

UserName / Pwd – jasperadmin/jasperadmin

Data sources :

 

Multi data sources :

 

Pwd - smcplotno15

 

 

 

 

Default Lib Jars :

 

Mail Configuration :

    <!-- <prop key="mail.smtp.sendpartial">true</prop>

                                                                     <prop key="mail.smtp.auth">true</prop>-->

                                                                     <prop key="mail.smtp.auth">true</prop>

                                                                      <prop key="mail.smtp.starttls.enable">true</prop>

                                                                         <prop key="mail.smtp.starttls.required">true</prop>

                                                                      </props>

 

 

 

                                                              report.scheduler.mail.sender.host=smtp.office365.com

 

                                                             report.scheduler.mail.sender.username=mailer@sathguru.com

 

                                                             report.scheduler.mail.sender.password=Mail@123#

 

                                                             report.scheduler.mail.sender.from=mailer@sathguru.com

 

                                                             report.scheduler.mail.sender.protocol=smtp

 

                                                            report.scheduler.mail.sender.port=587

 

                                                            report.scheduler.mail.smtp.starttls.enable=true

 

                                                           report.scheduler.mail.smtp.auth=true

Port Number change :

Open server.xml

 

Heap memory :

https://community.jaspersoft.com/wiki/configuring-tomcats-java-heap-size

File path : C:\Jaspersoft\jasperreports-server-cp-6.4.0\apache-tomcat\bin\setenv.bat

set JAVA_OPTS= --JvmMs 4096 --JvmMx 8192 --JvmSs 4 --JvmMs 4096 --JvmMx 8192 --JvmSs 4 %JAVA_OPTS%

No of simultaneous reports jobs / thread count

Path of files : C:\Jaspersoft\jasperreports-server-cp-6.4.0\apache-tomcat\webapps\jasperserver\WEB-INF\js.quartz.base.properties

Change to the following

org.quartz.threadPool.threadCount=4

org.quartz.threadPool.threadPriority=5

Timeout setting :

Path of files : C:\Jaspersoft\jasperreports-server-cp-6.4.0\apache-tomcat\webapps\jasperserver\WEB-INF\web.xml

   <session-config>

        <!-- Default to 20 minute session timeouts -->

        <session-timeout>120</session-timeout>

    </session-config>

max.pages

jasperreports.properties file(...WEB-INF/Classes) Added two more columns and Increase the limit like below

 

net.sf.jasperreports.governor.max.pages.enabled=true

net.sf.jasperreports.governor.max.pages=5000

 

Crosstab :

 

limit the crosstab bucket/measure count to prevent out of memory errors

net.sf.jasperreports.crosstab.bucket.measure.limit=100000000

                                                                                             

 

virtualizers :

C:\Jaspersoft\jasperreports-server-cp-6.4.0\apache-tomcat\webapps\jasperserver\WEB-INF

applicationcontext.xml  (....WEB-INF)  value should change 300 to 3000

 

    <!-- report virtualizers -->

    <bean id="fileVirtualizerFactory" class="com.jaspersoft.jasperserver.api.engine.common.service.impl.FileVirtualizerFactory">

        <property name="maxSize" value="3000"></property>

        <property name="directory" value="${java.io.tmpdir}"></property>

    </bean>

 

Pagenation :

jasperserver/WEB-INF/classes/jasperreports.properties
 ================================================

----------Please add below line to the CSV pagination ------------------

com.jaspersoft.jrs.export.csv.paginated=false
 com.jaspersoft.jrs.export.xls.paginated=false

 

Comments

Post a Comment

Popular posts from this blog

Jasper reports mail configuration

 path --> C:\Jaspersoft\jasperreports-server-cp-6.4.0\apache-tomcat\webapps\jasperserver\WEB-INF applicationContext-report-scheduling ----------------------------------------- <property name="javaMailProperties"> <props> <!--  <prop key="mail.smtp.sendpartial">true</prop> <prop key="mail.smtp.auth">false</prop>--> <prop key="mail.smtp.auth">true</prop> <prop key="mail.smtp.starttls.enable">true</prop> <prop key="mail.smtp.starttls.required">true</prop> </props> </property> js.quartz.properties ---------------------      report.scheduler.web.deployment.uri=http://172.16.5.216:8080/jasperserver report.scheduler.mail.sender.host=smtp.gmail.com report.scheduler.mail.sender.username=test@gmail.com report.scheduler.mail.sender.password=pwd report.scheduler.mail.sender.from=test@gmail.com report.scheduler.mail.sender.protocol=smtp report.sche...
Post a Comment
Read more

Calling Jasper report from DB to Jasper server

 PACKAGE cm_jasper_reports_pkg is FUNCTION construct_jasper_params(type_param type_jasper_params)  return varchar2 ; FUNCTION construct_json_for_jasper(v_job_label varchar2,v_job_desc varchar2,v_timeZone VARCHAR2,v_rep_name varchar2, v_params varchar2,v_output_filename varchar2,v_rep_format varchar2,v_rep_desc varchar2,v_body varchar2,v_to_mail varchar2,v_cc_mail varchar2,v_bcc_mail varchar2) return varchar2; function constrct_json_for_alfresco(v_job_label varchar2,v_job_desc varchar2,v_timeZone VARCHAR2,v_rep_name varchar2,v_params varchar2, v_output_filename varchar2,v_rep_format varchar2,v_rep_desc varchar2) return varchar2; FUNCTION schedule_jasper_job(p_url varchar2,p_content varchar2)  return varchar2 ; FUNCTION check_job_status( p_url in  varchar2) return varchar2; PROCEDURE load_binary_from_url (p_url  IN  VARCHAR2,p_rep_name varchar2,p_resource_nt_fnd out number); Function send_jasper_mails(v_to_mail varchar2,v_cc_mail varchar2,v_bcc_mail varchar2)...
Post a Comment
Read more