Producing csv or xls report from genReport.sh

I have been using genReport.sh to generate report in HTML and PDF format but I was interested to know if there was any way to get 'csv' or 'xls spreadsheet' output. I can do that online easily but I want to run some reports overnight and email the contents in these other formats.

Find more posts tagged with

Comments

averma

Hi mattfromoz,

You could extend org.eclipse.birt.report.engine.api.ReportRunner class and use BIRT Report Engine API (IDataExtractionTask) to extract data from a report document. The BIRT viewer uses this class to extract report data into CSV format. This class supports extracting data from the report document by specifying the result set and columns you would like to have extracted.

Ashwini

catchme33

hi

i addeed csv plugin
and tried to generate report in csv format
but ts giving me error

org.eclipse.birt.report.service.api.ReportServiceException: Report engine fails to initialize csv emitter, please make sure required libraries for this emitter are installed.

AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
faultSubcode:
faultString: org.eclipse.birt.report.service.api.ReportServiceException: Report engine fails to initialize csv emitter, please make sure required libraries for this emitter are installed.
faultActor:
faultNode:
faultDetail:
{http://xml.apache.org/axis/}stackTrace:org.eclipse.birt.report.service.api.ReportServiceException: Report engine fails to initialize csv emitter, please make sure required libraries for this emitter are installed.
at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(Unknown Source)
at org.eclipse.birt.report.service.actionhandler.BirtRunAndRenderActionHandler.__execute(Unknown Source)
at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(Unknown Source)
at org.eclipse.birt.report.presentation.aggregation.layout.EngineFragment.doService(Unknown Source)
at org.eclipse.birt.report.presentation.aggregation.AbstractBaseFragment.service(Unknown Source)
at org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Unknown Source)
at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGet(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain
..
.
.
.
.
.

.
.
.
.
.

so i wo'nt able to understand hat it deals with exactly
so kindly give suggestion , if any one hav any sort o fidea abt it
thx in adv.
B

mwilliams

This blog post by Virgil Dodson may help with using the CSV emitter:<br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.com/blog/2008-10-07/using-the-csv-emitter-with-birt-230/'>Using the CSV emitter with BIRT 2.3.0 » Blog - BIRT Exchange</a>