Skip to main content

Posts

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
Recent posts

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>-->              ...
Post a Comment
Read more

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