hi guys,
i'm trying to export my query result from dbadapter to a PDF report with jasper report library help.
i've already check this tutorial from AMIS
http://technology.amis.nl/2012/01/15/using-java-to-create-a-report-with-the-jasperreport-java-api/
and
http://technology.amis.nl/2012/02/05/create-a-jasperreport-from-oracle-bpel/
so i have a bpel process with a java embedding and calling a custom java application. the problem is. if i using this code in my java apps :
JasperPrint print = JasperFillManager.fillReport(report, parameters, new JRXmlDataSource(doc, "/TsEmplAttendanceCollection/TsEmplAttendance"));
then my report will turn into a white pdf.
if i tried to use a empty data source then the report will be printed with the parameter value that sent, but my table that get value from the datasource will be displaying null value.
i've already tried to init the JRXMLDataSource with a xml string or with a file. but none of it work.
here is my list of jar library
commons-beanutils-1.8.3
commons-collections-3.2.1
commons-digester-1.8.1
commons-logging-1.1.2
groovy-all-2.1.3
itext-2.1.7
jasper-compiler-jdt-5.5.15
jasperreports-5.0.0
jasperreports-extensions-3.5.3
poi-2.5.1-final-20040804
xalan
xerces-2.9.0
xml-apis
xml-apis-ext
i've tried to import this library with 2 way :
- when deploy my custom java jar i include this library in /lib folder and then put this .jar in <bpelSourceFolder>\SCA-INF\lib
- put all jar in <MW_HOME>\user_projects\domains\mdw_domain\lib
but even i don't import the library, i don't get the classnotfound exception.
am i missing something ? or anyone has another approach to export a pdf file using jasper report from bpel process ?