Error using Spudsoft emitter

pnaresh455
edited February 11, 2022 in Analytics #1
<p>Hi...,</p>
<p> </p>
<p>I have generated a report file with Page  breaks and Multi master pages. </p>
<p>So I am able to generate multiple excel sheets in single excel file using Birt Run as xlsx or spud_soft option.</p>
<p> </p>
<p>But  my problem is ,</p>
<p>When I am trying to run from Reporting server, burt runtime is not generating single excel file with multiple sheets. For this I tried by adding spud_soft emitter jar file and I have added following code in </p>
<p>BirtExportReportDialog.js </p>
<div> if(format == "xls")</div>
<div>{</div>
<div>action = action + " &__emitterid=uk.co.spudsoft.birt.emitters.excel.XlsEmitter";</div>
<div>}</div>
<div> </div>
<div>and  </div>
<div> </div>
<div>
<div>IReportEngineFactory factory = (IReportEngineFactory) Platform</div>
<div>.createFactoryObject(IReportEngineFactory.EXTENSION_REPORT_ENGINE_FACTORY);</div>
<div>engine = factory.createReportEngine(config);</div>
<div>IReportRunnable report = null;</div>
<div>try {</div>
<div>report = engine.openReportDesign(reportFilepath);</div>
<div>} catch (Exception e) {</div>
<div>System.err</div>
<div>.println("Report " + reportFilepath + " not found!\n");</div>
<div>engine.destroy();</div>
<div>return;</div>
<div>}</div>
<div>IRunAndRenderTask task = engine.createRunAndRenderTask(report);</div>
<div>RenderOption options = new RenderOption();</div>
<div>options.setEmitterID("uk.co.spudsoft.birt.emitters.excel.XlsEmitter"); // <span style="color:#ff0000;">this code I have added in reporting server</span></div>
<div>options.setOutputFormat("xls_spudsoft");</div>
<div>options.setOutputFileName(outputFileName);</div>
<div>task.setRenderOption(options);</div>
<div>task.setParameterValues(parameters);</div>
<div>try {</div>
<div>task.run();</div>
<div>} catch (EngineException e1) {</div>
<div>logger.error(e1);</div>
<div>e1.printStackTrace();</div>
<div>}</div>
<div>engine.destroy();</div>
<div> </div>
<div>I am getting this error</div>
<div> </div>
<div>
<div>2017-01-17 15:06:42 ERROR SchedularServiceImpl:195 - org.eclipse.birt.report.engine.api.EngineException: EmitterID uk.co.spudsoft.birt.emitters.excel.XlsEmitter for render option is invalid.</div>
<div>org.eclipse.birt.report.engine.api.EngineException: EmitterID uk.co.spudsoft.birt.emitters.excel.XlsEmitter for render option is invalid.</div>
<div>at org.eclipse.birt.report.engine.api.impl.EngineTask.setupRenderOption(EngineTask.java:2022)</div>
<div>at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:96)</div>
<div>at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)</div>
<div>at com.unipaynext.serviceimpl.SchedularServiceImpl.reports(SchedularServiceImpl.java:193)</div>
<div>at com.unipaynext.serviceimpl.SchedularServiceImpl.executeReport(SchedularServiceImpl.java:140)</div>
<div>at com.unipaynext.serviceimpl.SchedularServiceImpl.generateReport(SchedularServiceImpl.java:112)</div>
<div>at com.unipaynext.scheduler.SchedulerConfig.scheduleFixedDelayTask(SchedulerConfig.java:36)</div>
<div>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</div>
<div>at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)</div>
<div>at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)</div>
<div>at java.lang.reflect.Method.invoke(Unknown Source)</div>
<div>at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65)</div>
<div>at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)</div>
<div>at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)</div>
<div>at java.util.concurrent.FutureTask.runAndReset(Unknown Source)</div>
<div>at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)</div>
<div>at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)</div>
<div>at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)</div>
<div>at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)</div>
<div>at java.lang.Thread.run(Unknown Source)</div>
</div>
<div> </div>
<div>Please help me.</div>
</div>