Problem with a report export to a xls

i have a problem with the birt report, i create a table and put all the data on it, when i export it to xls it do well but when i give format to the numbers of the data the size of the export report in xls is to large like 58 MB and it cannot be open to save it without the xml,can anyone help me please.-

Find more posts tagged with

Comments

johnw

The stock XLS emitter is going to be a large file since it outputs the newer Office XML format. You can try one of the other XLS emitters that are out there, such as the Tribix emitter and see if that helps.

cloud

<blockquote class='ipsBlockquote' data-author="'johnw'" data-cid="83492" data-time="1317257017" data-date="28 September 2011 - 05:43 PM">
The stock XLS emitter is going to be a large file since it outputs the newer Office XML format. You can try one of the other XLS emitters that are out there, such as the Tribix emitter and see if that helps. </blockquote>
 
 
Thanks John 
 
But other report doesn't have that problem i export to xls and the max size of the file is near 1 MB but when i try with thid particular report his size is too large, could it be the data query it's a function with a lot of sub-select inside, this report goes well in the birt 2.3.2 but in the birt 2.6.2 is the problem of the size.-

johnw

This might be a bug. Could you submit that to the BIRT Bugzilla page?

RameshS

You can try "Native Excel Emitter Plug-in for BIRT"

http://www.birt-exchange.org/org/devshare/designing-birt-reports/1421-native-excel-emitter-plugin-for-birt/

If you are facing any performance issue, Let me know.

Good Luck.
Ramesh

RameshS

cloud

<blockquote class='ipsBlockquote' data-author="'RameshS'" data-cid="83648" data-time="1317544216" data-date="02 October 2011 - 01:30 AM">
You can try "Native Excel Emitter Plug-in for BIRT" 
 
<a class='bbc_url' href='http://www.birt-exchange.org/org/devshare/designing-birt-reports/1421-native-excel-emitter-plugin-for-birt/'>http://www.birt-exchange.org/org/devshare/designing-birt-reports/1421-native-excel-emitter-plugin-for-birt/</a> 
 
If you are facing any performance issue, Let me know. 
 
Good Luck. 
Ramesh </blockquote>
 
 
 
Thanks for the help 
How do i install that plug-in in my eclipse?

RameshS

You can download the latest plugin from

http://code.google.com/a/eclipselabs.org/p/native-excel-emitter-birt-plugin/downloads/list

If you want to test this plugin using eclipse,keep the plugin jar in your eclipse\plugins folder.

or

If you using ReportEngine api, Please follow the user guide.

Yaytay

You could also try the <a class='bbc_url' href='http://www.spudsoft.co.uk/?p=424'>SpudSoft BIRT Excel</a> emitters. 
I don't know how they compare to Ramesh's, it looks like we're trying to solve the same problems with other emitters. 
 
Installation is the same as with the Tribix emitter - if you are working in the designer just put the jar in the right place and modify the viewer.properties file; if you are working with the ReportEngine you need to extract the dependencies from my jar too.

vince284

<blockquote class='ipsBlockquote' data-author="'Yaytay'" data-cid="84677" data-time="1319870615" data-date="28 October 2011 - 11:43 PM">
You could also try the <a class='bbc_url' href='http://www.spudsoft.co.uk/?p=424'>SpudSoft BIRT Excel</a> emitters. 
I don't know how they compare to Ramesh's, it looks like we're trying to solve the same problems with other emitters. 
 
Installation is the same as with the Tribix emitter - if you are working in the designer just put the jar in the right place and modify the viewer.properties file; if you are working with the ReportEngine you need to extract the dependencies from my jar too. </blockquote>
 
Hi Yaytay, 
 
Can you please help me installing your jar. 
I followed the steps given in <a class='bbc_url' href='http://hg.io/yaytay/spudsoft-birt-excel-emitters/wiki/Home'>http://hg.io/yaytay/spudsoft-birt-excel-emitters/wiki/Home</a> 
 
But i am not able to understand the last step i.e. 
 
Modify your code to ensure that the correct emitter is used. 
if( "XLS".equalsIgnoreCase( outputFileFormat ) ) { 
renderOption.setEmitterID( "uk.co.spudsoft.birt.emitters.excel.XlsEmitter" ); 
} else if( "XLSX".equalsIgnoreCase( outputFileFormat ) ) { 
renderOption.setEmitterID( "uk.co.spudsoft.birt.emitters.excel.XlsxEmitter" ); 
} 
 
Where should i modify this code. 
Do i have to add it to my rptdesign file?? 
 
Thanks in advance

Yaytay

<blockquote class='ipsBlockquote' data-author="'vinayl'" data-cid="96317" data-time="1329476114" data-date="17 February 2012 - 03:55 AM">
Can you please help me installing your jar. </blockquote>
Sure. 
 
Are you trying to generate your report from inside Eclipse or inside an application that uses the ReportEngine API? 
The installation is very different for users of the ReportEngine API. 
 
Also, what version of BIRT are you using? 
 
And finally, are you trying to get XLS or XLSX output? 
I'd reccommend XLSX if you have thousands of rows, otherwise it doesn't matter. 
 
Jim

vince284

<blockquote class='ipsBlockquote' data-author="'Yaytay'" data-cid="96319" data-time="1329478806" data-date="17 February 2012 - 04:40 AM">
Sure. 
 
Are you trying to generate your report from inside Eclipse or inside an application that uses the ReportEngine API? 
The installation is very different for users of the ReportEngine API. 
 
Also, what version of BIRT are you using? 
 
And finally, are you trying to get XLS or XLSX output? 
I'd reccommend XLSX if you have thousands of rows, otherwise it doesn't matter. 
 
Jim </blockquote>
 
 
I am using Report engine 
 
regarding the version i am trying it on two versions on one i have 2.5 and on other i have 3.7.0 
 
For both the versions it is not working 
 
i placed your jar at WEB-INF\platform\plugins location in BIRT war and removed the other excel emitter. 
 
What needs to be done next??

Yaytay

<blockquote class='ipsBlockquote' data-author="'vinayl'" data-cid="96321" data-time="1329479695" data-date="17 February 2012 - 04:54 AM">
I am using Report engine 
 
regarding the version i am trying it on two versions on one i have 2.5 and on other i have 3.7.0 
 
For both the versions it is not working 
 
i placed your jar at WEB-INF\platform\plugins location in BIRT war and removed the other excel emitter. 
 
What needs to be done next?? </blockquote>
 
The file layout between 2.5 and 3.7 is very different, and currently my emitters only work on 3.7.0+ (they can work on 2.6, but I haven't worked out a suitable working methodology to support that yet). 
So make sure you are using 3.7.0 for now. 
 
With 3.7.0 the ReportEngine is supplied as a bunch of jars, rather than as an OSGi environment, so all the jars (including mine) need to be placed in the classpath somewhere - for a war this is typically in WEB-INF/lib (the directory containing org.eclipse.birt.runtime_3.7.0.v20110615-1818.jar). 
 
Because the ReportEngine is not using OSGi you also have to obtain the dependencies for my emmitters manually. 
To do this open the jar file for my emmitters (it's just a zip file) and copy out all the jars in the lib directory to the same location as the emmitters jar. 
 
This should leave you with a WEB-INF/lib that contains (amongst other things): 
<ul class='bbc'><li>org.eclipse.birt.runtime_3.7.0.v20110615-1818.jar</li><li>uk.co.spudsoft.birt.emitters.excel_0.6.0.201201271653.jar</li><li>poi-3.8-beta4-20110826.jar</li><li>poi-ooxml-3.8-beta4-20110826.jar </li><li>poi-ooxml-schemas-3.8-beta4-20110826.jar </li><li>slf4j-api-1.6.2.jar </li><li>xmlbeans-2.3.0.jar</li></ul>
 
 
If you have removed the built in Excel emmitter that should be sufficient. 
If you leave the built in emmitter in place you also need to tell BIRT which Excel emmitter to use, which you do by specifying a RenderOption. 
If you are calling the ReportEngine from your own code then you need somethin like the code on that wiki site to specify the RenderOption, but I don't think you are calling the ReportEngine from your own code, so look at this <a class='bbc_url' href='http://birtworld.blogspot.com/2011/07/replacing-default-birt-xls-emitter.html'>blog here</a>, which has detailed instruction on how to provide that render option as a URL query string parameter.

vince284

<blockquote class='ipsBlockquote' data-author="'Yaytay'" data-cid="96322" data-time="1329480641" data-date="17 February 2012 - 05:10 AM">
The file layout between 2.5 and 3.7 is very different, and currently my emitters only work on 3.7.0+ (they can work on 2.6, but I haven't worked out a suitable working methodology to support that yet). 
So make sure you are using 3.7.0 for now. 
 
With 3.7.0 the ReportEngine is supplied as a bunch of jars, rather than as an OSGi environment, so all the jars (including mine) need to be placed in the classpath somewhere - for a war this is typically in WEB-INF/lib (the directory containing org.eclipse.birt.runtime_3.7.0.v20110615-1818.jar). 
 
Because the ReportEngine is not using OSGi you also have to obtain the dependencies for my emmitters manually. 
To do this open the jar file for my emmitters (it's just a zip file) and copy out all the jars in the lib directory to the same location as the emmitters jar. 
 
This should leave you with a WEB-INF/lib that contains (amongst other things): 
<ul class='bbc'><li>org.eclipse.birt.runtime_3.7.0.v20110615-1818.jar</li><li>uk.co.spudsoft.birt.emitters.excel_0.6.0.201201271653.jar</li><li>poi-3.8-beta4-20110826.jar</li><li>poi-ooxml-3.8-beta4-20110826.jar </li><li>poi-ooxml-schemas-3.8-beta4-20110826.jar </li><li>slf4j-api-1.6.2.jar </li><li>xmlbeans-2.3.0.jar</li></ul>
 
 
If you have removed the built in Excel emmitter that should be sufficient. 
If you leave the built in emmitter in place you also need to tell BIRT which Excel emmitter to use, which you do by specifying a RenderOption. 
If you are calling the ReportEngine from your own code then you need somethin like the code on that wiki site to specify the RenderOption, but I don't think you are calling the ReportEngine from your own code, so look at this <a class='bbc_url' href='http://birtworld.blogspot.com/2011/07/replacing-default-birt-xls-emitter.html'>blog here</a>, which has detailed instruction on how to provide that render option as a URL query string parameter. </blockquote>
 
 
I tried that the thing which is given here <a class='bbc_url' href='http://birtworld.blogspot.com/2011/07/replacing-default-birt-xls-emitter.html'>http://birtworld.blogspot.com/2011/07/replacing-default-birt-xls-emitter.html</a> 
 
But m getting an error - org.eclipse.birt.report.service.api.ReportServiceException: EmitterID uk.co.spudsoft.birt.emitters.excel.XlsxEmitter for render option is invalid. 
 
Even facing the same error for xls 
 
I have replaced the jars as mentioned above but still facing this error

Yaytay

<blockquote class='ipsBlockquote' data-author="'vinayl'" data-cid="96325" data-time="1329483528" data-date="17 February 2012 - 05:58 AM">
I tried that the thing which is given here <a class='bbc_url' href='http://birtworld.blogspot.com/2011/07/replacing-default-birt-xls-emitter.html'>http://birtworld.blogspot.com/2011/07/replacing-default-birt-xls-emitter.html</a> 
 
But m getting an error - org.eclipse.birt.report.service.api.ReportServiceException: EmitterID uk.co.spudsoft.birt.emitters.excel.XlsxEmitter for render option is invalid. 
 
Even facing the same error for xls 
 
I have replaced the jars as mentioned above but still facing this error </blockquote>
 
Can you attach a complete directory tree listing of the expanded war file (ls -lR on Linux, tree /F on Windows)? 
 
Jim

abhijitKol

Hi Ramesh,

I am using open source birt to implement reports module in my web application.I am using BIRT 3.7 and Native Excel emitters to export chart to excel.It is working fine for single chart, but if there is multiple charts in a page,then the first chart is coming fine,rest charts are getting clubbed within rows.If I expand the rows manually,then I am able to see the chart.
Could you please help me, why charts are not coming properly in the excel sheet.

Thanks in advance.