topic Re: tJasperServerExec output to Excel doesn't work in Talend Studio

tJasperServerExec output to Excel doesn't work

Anonymous — Wed, 06 Apr 2016 06:13:09 GMT

Hi I'm trying to run a job which uses the tJasperServerExec component and which I would like to export the report to Excel, but this doesn't seem to work. PDF and rtf for example are no problem, but when using xls I get this error:
Exception in thread "main" java.lang.NoSuchMethodError: jxl.WorkbookSettings.setUseTemporaryFileDuringWrite(Z)V
at net.sf.jasperreports.engine.export.JExcelApiExporter.openWorkbook(JExcelApiExporter.java:283)
at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:596)
at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:377)
at post.requestjob_0_1.RequestJob.tOracleInput_1Process(RequestJob.java:1613)
at post.requestjob_0_1.RequestJob.runJobInTOS(RequestJob.java:7407)
at post.requestjob_0_1.RequestJob.main(RequestJob.java:7108)
My studio is 5.6.2, calling a JRS 6.1.1 Commercial.
Any ideas anyone?
Thanks a lot

Re: tJasperServerExec output to Excel doesn't work

Anonymous — Wed, 06 Apr 2016 08:15:44 GMT

Use tJasperReportExec (use your JasperStudio design directly without a JasperServer)
https://exchange.talend.com/#marketplaceproductoverview:gallery=marketplace%252F1&pi=marketplace%252F1%252Fproducts%252F549%252Fitems%252F2240
or tJasperServerReportStarter (start a report deployed on the server)
https://exchange.talend.com/#marketplaceproductoverview:gallery=marketplace%252F1&pi=marketplace%252F1%252Fproducts%252F555%252Fitems%252F830
instead. The component tJasperServerExec is completely outdated and not maintained anymore and actually not very clever.

Re: tJasperServerExec output to Excel doesn't work

Anonymous — Wed, 06 Apr 2016 10:50:00 GMT

Hi jlolling,

thanks for the reply.
In the meanwhile I've found this plugin: which seems to be the updated version, but here I receive another error:

I know there are also options to point to the jrxml, but our goal is to do some load testing on the server, so I need to be able to use the server for the rendering.

regards,
Christoph

Re: tJasperServerExec output to Excel doesn't work

Anonymous — Wed, 06 Apr 2016 18:10:35 GMT

You do not do any load testings on the server with tJasperServerExec!
[font=Verdana, Helvetica, Arial, sans-serif] This component downloads the jrxml file and start the report locally.[/font]
[font=Verdana, Helvetica, Arial, sans-serif] If you want real load tests use the component [/font] tJasperServerReportStarter which starts the report really on the server!
With the components tJasperServerFile* components you can download the results or cleanup the server repository.
Search in Talend Exchange for tJasperServerFile and you will find a couple of useful components handling content resources on the jasper server.