nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Image and Chart not exported

Mubashar

Hello Everyone, 
 
I am facing a problem while exporting report header image and chart in xls format. I am using Birt 3.7 API and have downloaded and configured class path for this API 
 
exelero-xls-emitter-1.00-beta.jar . Downloaded from <a class='bbc_url' href='http://sourceforge.net/projects/exemitter-xlsem/'>http://sourceforge.net/projects/exemitter-xlsem/</a> 
 
and overide the default emitter with following code 
 
else if( format.equalsIgnoreCase("xls") ){ 
EXCELRenderOption xlsOptions = new EXCELRenderOption(); 
xlsOptions.setOutputFormat("xls"); 
xlsOptions.setOutputFileName("output/resample/ps.xls"); 
xlsOptions.setOption(IRenderOption.EMITTER_ID, "org.uguess.birt.report.engine.emitter.xls"); 
 
runAndRenderTask.setRenderOption(xlsOptions); 
 
} 
 
 
 
But Still I am unable to export the image and charts with following exception 
 
 
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.eclipse.birt.report.engine.api.EngineException: EmitterID org.uguess.birt.report.engine.emitter.xls for render option is invalid. 
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:927) 
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:811) 
javax.servlet.http.HttpServlet.service(HttpServlet.java:621) 
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:796) 
javax.servlet.http.HttpServlet.service(HttpServlet.java:728) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) 
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) 
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) 
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) 
org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:64) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) 
org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) 
org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) 
org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) 
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) 
org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) 
org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) 
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) 
org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192) 
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) 
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) 
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
 
 
 
Please Help me. 
 
Thanks & Regards, 
Mubashar

Find more posts tagged with

Comments

mwilliams

Try this emitter instead:

http://www.birt-exchange.com/be/marketplace/app-showcase/?app=102

FYI - Images and charts should export with the enhanced XLS emitter that will be in BIRT 4.3.

Mubashar

Thanks williams. You Always answering.. 
 
Can you Please provide me an example i have configured but still unable to generate report output in XLS format... Steps Followed for Runtime API: 
1. Copied at build & CLASS PATH ( All files list in attachment) 
uk.co.spudsoft.birt.emitters.excel_0.8.0.201306032053.jar 
 
2. Added Code 
 
 EXCELRenderOption xlsOptions = new EXCELRenderOption(); 
xlsOptions.setOutputFormat("xls"); 
xlsOptions.setOutputFileName("ps.xls"); 
xlsOptions.setOption(IRenderOption.EMITTER_ID, "uk.co.spudsoft.birt.emitters.excel.XlsEmitter"); 
runAndRenderTask.setRenderOption(xlsOptions); 
 
Dear Still i am unable to export in XLS , everytime i am getting an empty XLS file. F 
Please help me, I will be highly thankful. 
 
Regards, 
Mubashar

mwilliams

What version of 3.7 are you using? 3.7.0, 3.7.1, or 3.7.2? Let me know. I'll try to run a report with Java with your same version.

Mubashar

Thanks again, Williams

Following binaries i have added in application

org.eclipse.core.runtime_3.7.0.v20110110.jar
org.eclipse.birt.runtime_3.7.1.v20110913-1734.jar
uk.co.spudsoft.birt.emitters.excel_0.8.0.201306032053.jar

all names of birt library files has been attached for you review.

Looking forward you response.

Thanks,
Mubashar

mwilliams

Take a look at the code uses in this post:

http://www.birt-exchange.org/org/forum/index.php/topic/29545-ireportengine-with-spudsoft-excel-emitter-margin-constant-error/

Let me know if you still have issues after switching to this.

Mubashar

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="117424" data-time="1370624916" data-date="07 June 2013 - 10:08 AM">
Take a look at the code uses in this post: 
 
<a class='bbc_url' href='http://www.birt-exchange.org/org/forum/index.php/topic/29545-ireportengine-with-spudsoft-excel-emitter-margin-constant-error/'>http://www.birt-exchange.org/org/forum/index.php/topic/29545-ireportengine-with-spudsoft-excel-emitter-margin-constant-error/</a> 
 
Let me know if you still have issues after switching to this. </blockquote>

Mubashar

Dear Williams, 
 
Thanks for helping. Still i am unable to export the image or chart to excel after integrating code from your last response and followed folloing steps. 
 
Step-1: I am using BIRT and spring integration enviornment as available from 
<a class='bbc_url' href='http://www.springsource.org/BusinessIntelligenceWithSpringAndBIRT'>http://www.springsource.org/BusinessIntelligenceWithSpringAndBIRT</a> 
 
Step-2: I have updated my project with birt-runtime-4_2_2. and copied all libararies from birt-runtime-4_2_2\ReportEngine\lib to WEB-INF\lib\Birt4.2.2 
 
Step-3: Added emitter to project WEB-INF\lib\BIRT_EXPORT\uk.co.spudsoft.birt.emitters.excel_0.8.0.201306032053.jar along with supporing libararies and delete apache\poi from birt-runtime-4_2_2 due to version conflict as mentioned in topic which you have refered in your last reply. 
 
If i run the attached chart.rptdesign , in HTML and PDF i am geeting the right output but if i want to extract the same chart in XLS , i am getting Empty XLS file same as which i aleady have posted in the same topic. 
 
Following code works fine for PDF and HTML format but generate empty XLS file and excel file Reports.xls is retured instead of "GoodLuck.xls" as mentioned in following code 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>

protected void renderMergedOutputModel(
Map map, HttpServletRequest request,
HttpServletResponse response) throws Exception {

System.out.println("Request recieved for report generation. Please wait..... ");

String reportName = request.getParameter( this.reportNameRequestParameter );
String format = request.getParameter( this.reportFormatRequestParameter );
ServletContext sc = request.getSession().getServletContext();

IReportRunnable runnable = null;

runnable = birtEngine.openReportDesign( sc.getRealPath("/Reports")+"/"+reportName );
IRunAndRenderTask runAndRenderTask = birtEngine.createRunAndRenderTask(runnable);
runAndRenderTask.setParameterValues(discoverAndSetParameters( runnable, request ));

System.out.println("BIRT MIMEType : "+birtEngine.getMIMEType( format ));
// output application/vnd.ms-excel

response.setContentType( birtEngine.getMIMEType( format ));//

IRenderOption options = null == this.renderOptions ? new RenderOption() : this.renderOptions;

System.out.println("XLS Export format");

if( format.equalsIgnoreCase("pdf") ){
PDFRenderOption pdfOptions = new PDFRenderOption( options );
pdfOptions.setOutputFormat("pdf");
pdfOptions.setOption(IPDFRenderOption.PAGE_OVERFLOW, IPDFRenderOption.FIT_TO_PAGE_SIZE);
pdfOptions.setOutputStream(response.getOutputStream());
runAndRenderTask.setRenderOption(pdfOptions);
}else
if( format.equalsIgnoreCase("xls") ){
// EXCELRenderOption xlsoptions = new EXCELRenderOption();
RenderOption xlsoptions = new RenderOption();
xlsoptions.setOption("ExcelEmitter.SingleSheet", true);
xlsoptions.setOption("ExcelEmitter.DisplayGridLines", true);
xlsoptions.setOption("ExcelEmitter.DisplayRowColHeadings", true);
xlsoptions.setOption("ExcelEmitter.DisplayZeros", true);
xlsoptions.setOption(ExcelEmitter.STRUCTURED_HEADER, false);
xlsoptions.setOutputFormat(format);
xlsoptions.setEmitterID("uk.co.spudsoft.birt.emitters.excel.XlsEmitter");
xlsoptions.setOutputFileName("GoodLuck.xls");

runAndRenderTask.setRenderOption(xlsoptions);
}
runAndRenderTask.run();
runAndRenderTask.close();

}
</pre>
 
 
 
For your review i have attached 
 
1. chart.rptdesign ( i am unable to upload it due to permission , if you need i will email u.) 
2. reports.pdf which generated sucessfully from chart.rptdesign 
3. reports.xls empty XLS generated and need your help. (i am unable to upload it due to permission , if you need i will email u.) 
 
4 . All the library file names which i have used in this 
 
 
So, Dear please help me as still i am unable to produce XLS file for Chart and report same like attached reports.pdf. 
 
 
Looking forward your response. 
 
Thanks Alot. 
 
 
Regards, 
Mubashar

mwilliams

Are you getting any errors at all? I ran a report with a chart with no issue.

Mubashar

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="117522" data-time="1370923886" data-date="10 June 2013 - 09:11 PM">
Are you getting any errors at all? I ran a report with a chart with no issue. </blockquote>
 
 
Dear Williams, 
 
I am not getting any error while generating XLS but the problem is as a response i got only XLS file having no data either chart or image...... 
But the same chart in pdf and html format is generating fine if i set report format to pdf or html.... 
 
I think the emitter is not working as if i see the tomcat console while xls generation following log is printing 
 
<blockquote class='ipsBlockquote' >
 
Jun 10, 2013 11:59:12 PM uk.co.spudsoft.birt.emitters.excel.framework.Logger info 
INFO: start:org.eclipse.birt.report.engine.content.impl.ReportContent@1b1694e 
Jun 10, 2013 11:59:13 PM org.eclipse.birt.data.engine.executor.DataSourceQuery execute 
INFO: ODA query execution time: 16 ms 
Jun 10, 2013 11:59:13 PM org.eclipse.birt.data.engine.impl.QueryResults getResultIterator 
INFO: ODI query execution: 172 ms 
Jun 10, 2013 11:59:18 PM org.eclipse.birt.data.engine.executor.DataSourceQuery execute 
INFO: ODA query execution time: 0 ms 
Jun 10, 2013 11:59:18 PM org.eclipse.birt.data.engine.impl.QueryResults getResultIterator 
INFO: ODI query execution: 219 ms 
Jun 10, 2013 11:59:19 PM org.eclipse.birt.data.engine.impl.QueryResults getResultIterator 
INFO: ODI query execution: 15 ms 
Jun 10, 2013 11:59:19 PM org.eclipse.birt.data.engine.impl.DataEngineImpl shutdown 
INFO: Data Engine lifetime: 7968 ms 
 </blockquote>
 
for pdf generation log please find attached pdfGenerationLog.txt..... 
 
Dear, I think i am missing some step thats why i have written detail which i am following.... 
 
Thanks for response... 
 
Regards, 
 
Mubashar

mwilliams

The only difference between the render option code for xls that you use and that I used was I did not have these lines:

EXCELRenderOption xlsoptions = new EXCELRenderOption();
xlsoptions.setOutputFormat(format);

Mubashar

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="117565" data-time="1370980453" data-date="11 June 2013 - 12:54 PM">
The only difference between the render option code for xls that you use and that I used was I did not have these lines: 
 
EXCELRenderOption xlsoptions = new EXCELRenderOption(); 
xlsoptions.setOutputFormat(format); </blockquote>
 
 
Dear Williams. 
 
Thanks for your superb support, my issue resolved by placing emitter and plugin library file in the same birt runtime folder. 
 
 
 
 
Regards, 
Mubashar

mwilliams

Great! Glad to hear it's solved. Let us know whenever you have questions!