Spudsoft emitter Image and Chart not exported

Hello! I have a problem with spudsoft emitter for BIRT runtime environment.I have no idea where I should indicate that BIRT should use spudsoft emitter instead of default emitter.Maybe anyone can help me and tell me where I should include this code?(I follow this page <a data-ipb='nomediaparse' href='https://bitbucket.org/yaytay/spudsoft-birt-excel-emitters/wiki/Home'>https://bitbucket.org/yaytay/spudsoft-birt-excel-emitters/wiki/Home</a>) TIA Michal

Find more posts tagged with

Comments

mwilliams

So, you're writing Java code, not using the viewer? The code for using the emitter should look something like this: <pre class="_prettyXprint _linenums:0">IRenderOption options = null; options = new EXCELRenderOption(outputFormat: "xls"; options.setEmitterID("uk.co.spudsoft.birt.emitters.excel.XlsEmitter");</pre>

ashok22890@gmail.com

Hello, I am new to BIRT.I am creating report in default BIRT emiiter and i will get output in xls. Now i need to add Bar chart in the same report.I got the bar chart in pdf format.But not in xls. i am using,Eclipse: Kepler Service Release 1BIRT :4.3(it contains plugin with default (uk.co.spudsoft.birt.emitters.excel_4.3.1.v201308301349) spudsoft. i dont do any integrations in eclipse and as well as birt with spudsoft.Guide me how to create report with Bar chart. Thanks,Ashok

jmaulny

<blockquote class="ipsBlockquote" data-author="ashok22890@gmail.com" data-cid="122701" data-time="1385456097"><div>Hello, I am new to BIRT.I am creating report in default BIRT emiiter and i will get output in xls. Now i need to add Bar chart in the same report.I got the bar chart in pdf format.But not in xls. i am using,Eclipse: Kepler Service Release 1BIRT :4.3(it contains plugin with default (uk.co.spudsoft.birt.emitters.excel_4.3.1.v201308301349) spudsoft. i dont do any integrations in eclipse and as well as birt with spudsoft.Guide me how to create report with Bar chart. Thanks,Ashok</div></blockquote> Try using the xls_spudsoft emitter : <div> <pre class="_prettyXprint"> EXCELRenderOption xlsOptions = new EXCELRenderOption(); xlsOptions.setOutputFormat("xls_spudsoft"); xlsOptions.setBaseURL(baseUrl); xlsOptions.setImageHandler(new HTMLServerImageHandler()); xlsOptions.setOutputStream(resp.getOutputStream()); iRenderTask.setRenderOption(xlsOptions); </pre>Regards,Jeremy</div>

ashok22890@gmail.com

Hi jeremy, When i using this,<div><pre class="_prettyXprint">task = eng.createRunAndRenderTask(design); EXCELRenderOption xl=new EXCELRenderOption();xl.setOutputFormat("xls_spudsoft");xl.setEmitterID( "uk.co.spudsoft.birt.emitters.excel.XlsEmitter" );xl.setOutputFileName(reportoutput+"/"+reportsname); task.setRenderOption(xl);</pre>i got the above error.If i am not using,<pre class="_prettyXprint">xl.setOutputFormat("xls_spudsoft");xl.setEmitterID( "uk.co.spudsoft.birt.emitters.excel.XlsEmitter" );</pre>and used instead of,<pre class="_prettyXprint">xl.setOutputFormat("xls");</pre></div>i got an output.While using "xls_spudsoft" i got an error and i am using java.

ashok22890@gmail.com

Hi Jeremy, Here i attache my java file,please find and comment as the same. <div> </div><div> </div><div><pre class="_prettyXprint">import org.eclipse.birt.report.engine.api.EXCELRenderOption;import org.eclipse.birt.report.engine.api.EngineConfig;import org.eclipse.birt.report.engine.api.IExcelRenderOption;import org.eclipse.birt.report.engine.api.IReportRunnable;import org.eclipse.birt.report.engine.api.IRunAndRenderTask;import org.eclipse.birt.report.engine.api.ReportEngine;public class CallReport{public CallReport() {String reports = "status_report.rptdesign"; String reportsname = "Report.xls"; String reportpath="C:/"; EngineConfig conf = null;ReportEngine eng = null;IReportRunnable design = null;IRunAndRenderTask task = null;String reportoutput="C:/";String exactreport = reportpath+"/"+reports;conf = new EngineConfig();conf.setEngineHome(" ");eng = new ReportEngine( conf );try{design = eng.openReportDesign(exactreport); } catch (Exception e){System.out.println("An error occured during the opening of the report file!");System.out.println(e);}task = eng.createRunAndRenderTask(design);EXCELRenderOption xl=new EXCELRenderOption();//xl.setOutputFormat("xls");xl.setOutputFormat("xls_spudsoft");xl.setEmitterID( "uk.co.spudsoft.birt.emitters.excel.XlsEmitter" );//xl.setOption(IExcelRenderOption.HIDE_GRIDLINES, new Boolean(true));xl.setOutputFileName(reportoutput+"/"+reportsname); task.setRenderOption(xl); try { task.run(); Thread.sleep(15000); } catch (Exception e) { System.out.println("An error occured while running the report!"); System.out.println(e); } System.out.println("Report Created"); eng.destroy();System.exit(0);}public static void main(String[] args) {CallReport obj = new CallReport(); }}</pre>Thanks, Ashok </div>

jmaulny

Do you have any Exception caught here : <blockquote class="ipsBlockquote"> [color=rgb(0,0,136);]try[/color] 
 [color=rgb(102,102,0);]{[/color] 
 task[color=rgb(102,102,0);].[/color]run[color=rgb(102,102,0);]();[/color] 
 [color=rgb(102,0,102);]Thread[/color][color=rgb(102,102,0);].[/color]sleep[color=rgb(102,102,0);]([/color][color=rgb(0,102,102);]15000[/color][color=rgb(102,102,0);]);[/color] 
 [color=rgb(102,102,0);]}[/color] 
 [color=rgb(0,0,136);]catch[/color] [color=rgb(102,102,0);]([/color][color=rgb(102,0,102);]Exception[/color] e[color=rgb(102,102,0);])[/color] 
 [color=rgb(102,102,0);]{[/color] 
 [color=rgb(102,0,102);]System[/color][color=rgb(102,102,0);].[/color][color=rgb(0,0,136);]out[/color][color=rgb(102,102,0);].[/color]println[color=rgb(102,102,0);]([/color][color=rgb(0,136,0);]"An error occured while running the report!"[/color][color=rgb(102,102,0);]);[/color] 
 [color=rgb(102,0,102);]System[/color][color=rgb(102,102,0);].[/color][color=rgb(0,0,136);]out[/color][color=rgb(102,102,0);].[/color]println[color=rgb(102,102,0);]([/color]e[color=rgb(102,102,0);]);[/color] 
 
[color=rgb(102,102,0);]}[/color]</blockquote> ?

ashok22890@gmail.com

Yeah,I got an exception and errors.<pre class="_prettyXprint">org.eclipse.birt.report.engine.api.impl.EngineTask handleFatalExceptionsSEVERE: An error happened while running the report. Cause:java.lang.ArrayIndexOutOfBoundsException: 60at org.eclipse.birt.report.engine.css.dom.ComputedStyle.getProperty(ComputedStyle.java:32)at uk.co.spudsoft.birt.emitters.excel.BirtStyle.<init>(BirtStyle.java:129)at uk.co.spudsoft.birt.emitters.excel.handlers.AbstractRealTableHandler.startTable(AbstractRealTableHandler.java:112)at uk.co.spudsoft.birt.emitters.excel.handlers.TopLevelTableHandler.startTable(TopLevelTableHandler.java:42)at uk.co.spudsoft.birt.emitters.excel.handlers.PageHandler.startTable(PageHandler.java:355)at uk.co.spudsoft.birt.emitters.excel.ExcelEmitter.startTable(ExcelEmitter.java:300)at org.eclipse.birt.report.engine.emitter.CompositeContentEmitter.startTable(CompositeContentEmitter.java:306)at org.eclipse.birt.report.engine.layout.html.HTMLTableLayoutEmitter.startTable(HTMLTableLayoutEmitter.java:384)at org.eclipse.birt.report.engine.emitter.ContentEmitterUtil.startContent(ContentEmitterUtil.java:50)at org.eclipse.birt.report.engine.layout.html.buffer.ContainerBufferNode.start(ContainerBufferNode.java:83)at org.eclipse.birt.report.engine.layout.html.buffer.ContainerBufferNode.start(ContainerBufferNode.java:79)at org.eclipse.birt.report.engine.layout.html.buffer.ContainerBufferNode.start(ContainerBufferNode.java:79)at org.eclipse.birt.report.engine.layout.html.buffer.ContainerBufferNode.flush(ContainerBufferNode.java:48)at org.eclipse.birt.report.engine.layout.html.buffer.HTMLPageBuffer.endRow(HTMLPageBuffer.java:206)at org.eclipse.birt.report.engine.layout.html.buffer.HTMLPageBuffer.endContainer(HTMLPageBuffer.java:140)at org.eclipse.birt.report.engine.layout.html.buffer.TableBreakBuffer.endContainer(TableBreakBuffer.java:360)at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.end(HTMLStackingLM.java:42)at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:141)at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)at org.eclipse.birt.report.engine.layout.html.HTMLTableBandLM.layoutChildren(HTMLTableBandLM.java:67)at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)at org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren(HTMLTableLM.java:132)at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:180)at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)at com.overall.CallReport.run(CallReport.java:415)at java.util.TimerThread.mainLoop(Timer.java:555)at java.util.TimerThread.run(Timer.java:505)An error occured while running the report!org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.</pre>Do the needful.Thanks.

yusufnazir

Hi All, Trying to work with the spudsoft emitter, but no file is generated.I checked the code and when i switch back to default xls emitter the output file gets generated.Also no exception is thrown.I am using birt version 4.3.1 I hope someone can give me a solution to my problem.<pre class="_prettyXprint">private RenderOption setReportOutputFormatForBirt(Long outputFormat, OutputStream outputStream) { RenderOption options = null; switch (outputFormat.intValue()) { case 2: options = new RenderOption(); options.setOutputStream(outputStream); options.setOutputFormat("doc"); break; case 3: options = new EXCELRenderOption(); options.setOutputStream(outputStream); options.setOutputFormat("xls_spudsoft"); options.setEmitterID("uk.co.spudsoft.birt.emitters.excel.XlsEmitter"); options.setOption(ExcelEmitter.STRUCTURED_HEADER, false); break; case 4: options = new PDFRenderOption(); options.setOutputStream(outputStream); options.setOutputFormat(PDFRenderOption.OUTPUT_FORMAT_PDF); break; case 5: break; default: break; } return options; }</pre>

A. Farhan

<blockquote class="ipsBlockquote" data-author="yusufnazir" data-cid="126772" data-time="1395171112"><div> Hi All, Trying to work with the spudsoft emitter, but no file is generated.I checked the code and when i switch back to default xls emitter the output file gets generated.Also no exception is thrown.I am using birt version 4.3.1 I hope someone can give me a solution to my problem.<pre class="_prettyXprint">private RenderOption setReportOutputFormatForBirt(Long outputFormat, OutputStream outputStream) { RenderOption options = null; switch (outputFormat.intValue()) { case 2: options = new RenderOption(); options.setOutputStream(outputStream); options.setOutputFormat("doc"); break; case 3: options = new EXCELRenderOption(); options.setOutputStream(outputStream); options.setOutputFormat("xls_spudsoft"); options.setEmitterID("uk.co.spudsoft.birt.emitters.excel.XlsEmitter"); options.setOption(ExcelEmitter.STRUCTURED_HEADER, false); break; case 4: options = new PDFRenderOption(); options.setOutputStream(outputStream); options.setOutputFormat(PDFRenderOption.OUTPUT_FORMAT_PDF); break; case 5: break; default: break; } return options; }</pre>Yeah, I got this problem too. Care to share how to fix this? My BiRT Engine version is 4.3.1</div></blockquote>

mwilliams

I have no problem using the spudsoft emitter. Is the issue you're having only when you're using output stream? What are you doing with the output stream?

anil7496

Hi All,
 i am using birt 4.3.1 ,exporting data to xlsx files.here is the my code
<pre class="_prettyXprint _lang-nocode">

// createData(object, title);
// end of mock data

//resp.setContentType("application/vnd.ms-excel");
resp.setHeader("Content-Disposition", "inline; filename="+title+".xlsx");
ServletContext sc = req.getSession().getServletContext();
IReportEngine birtReportEngine = BirtEngine.getBirtReportEngine(sc);
IReportRunnable design;
try {
// Open report design
design = birtReportEngine.openReportDesign(new ByteArrayInputStream(createReport(sc, title, req)));
// create task to run and render report
IRunAndRenderTask task = birtReportEngine
.createRunAndRenderTask(design);
Map<String, Object> contextMap = new HashMap<String, Object>();
contextMap.put("data", data);
task.setAppContext(contextMap);

IExcelRenderOption excelOptions = new EXCELRenderOption();
excelOptions.setOutputFormat("xlsx");
excelOptions.setOutputStream(resp.getOutputStream());
task.setRenderOption(excelOptions);

// run report
task.run();
task.close();
} catch (Exception e) {

e.printStackTrace();
throw new ServletException(e);
}
}
</pre>
i am getting below error,
 
 
Caused by: java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 60
 at org.eclipse.birt.report.engine.css.dom.ComputedStyle.getProperty(ComputedStyle.java:32)
 at uk.co.spudsoft.birt.emitters.excel.BirtStyle.<init>(BirtStyle.java:129)
 at uk.co.spudsoft.birt.emitters.excel.handlers.AbstractRealTableHandler.startTable(AbstractRealTableHandler.java:112)
 at uk.co.spudsoft.birt.emitters.excel.handlers.TopLevelTableHandler.startTable(TopLevelTableHandler.java:42)
 at uk.co.spudsoft.birt.emitters.excel.handlers.PageHandler.startTable(PageHandler.java:355)
 at uk.co.spudsoft.birt.emitters.excel.ExcelEmitter.startTable(ExcelEmitter.java:300)
 at org.eclipse.birt.report.engine.emitter.CompositeContentEmitter.startTable(CompositeContentEmitter.java:306)
 at org.eclipse.birt.report.engine.layout.html.HTMLTableLayoutEmitter.startTable(HTMLTableLayoutEmitter.java:384)
 at org.eclipse.birt.report.engine.emitter.ContentEmitterUtil.startContent(ContentEmitterUtil.java:50)
 at org.eclipse.birt.report.engine.layout.html.buffer.ContainerBufferNode.start(ContainerBufferNode.java:83)
 at org.eclipse.birt.report.engine.layout.html.buffer.ContainerBufferNode.start(ContainerBufferNode.java:79)
 at org.eclipse.birt.report.engine.layout.html.buffer.ContainerBufferNode.start(ContainerBufferNode.java:79)
 at org.eclipse.birt.report.engine.layout.html.buffer.ContainerBufferNode.start(ContainerBufferNode.java:79)
 at org.eclipse.birt.report.engine.layout.html.buffer.HTMLPageBuffer.startContent(HTMLPageBuffer.java:113)
 at org.eclipse.birt.report.engine.layout.html.buffer.TableBreakBuffer.startContent(TableBreakBuffer.java:287)
 at org.eclipse.birt.report.engine.layout.html.HTMLLeafItemLM.start(HTMLLeafItemLM.java:67)
 at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:139)
 at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
 at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
 at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
 at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:111)
 at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:160)
 at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
 at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
 at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
 at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
 at org.eclipse.birt.report.engine.layout.html.HTMLTableBandLM.layoutChildren(HTMLTableBandLM.java:67)
 at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
 at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
 at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
 at org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren(HTMLTableLM.java:132)
 at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
 at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
 at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
 at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
 at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:180)
 
 
Any help on this would be Appreciable

mwilliams

I'm not sure it has to do with your Java code. It might be a bug with the spudsoft emitter and how it handles styles or something. At least that's what it looks like in your error stack.. Are you using css styles?