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; } } }

Report bursting in excel using BIRT

Birtnewbe

I have a BIRT report that needs to generates couple of million records and the end user would like to get the output in excel and they want only 1 million records per tab( anyhow i believe that is the limit of excel) so how do i do tab bursting in BIRT can this be done?

Find more posts tagged with

Comments

ashish13

<blockquote class='ipsBlockquote' data-author="'Birtnewbe'" data-cid="101628" data-time="1338817648" data-date="04 June 2012 - 06:47 AM">
I have a BIRT report that needs to generates couple of million records and the end user would like to get the output in excel and they want only 1 million records per tab( anyhow i believe that is the limit of excel) so how do i do tab bursting in BIRT can this be done? </blockquote>
 
Use excel emitter (native or spudsoft) for the same.

Birtnewbe

<blockquote class='ipsBlockquote' data-author="'ashish13'" data-cid="101665" data-time="1338862697" data-date="04 June 2012 - 07:18 PM">
Use excel emitter (native or spudsoft) for the same. </blockquote>
 
Can you please give an idea how emitter can be implemented? i am never used one before.

georgeh12

Yaytay

<blockquote class='ipsBlockquote' data-author="'Birtnewbe'" data-cid="101880" data-time="1338910463" data-date="05 June 2012 - 08:34 AM">
Can you please give an idea how emitter can be implemented? i am never used one before. </blockquote>
You shouldn't need to write an emitter, just use one of the existing ones. 
There is a (slightly out of date) summary of the different emitters available here: <a class='bbc_url' href='http://www.spudsoft.co.uk/2011/10/the-spudsoft-birt-excel-emitters/'>http://www.spudsoft.co.uk/2011/10/the-spudsoft-birt-excel-emitters/</a> 
 
For an XLS workbook the row limit is just ~65000, so I assume you are planning on using XLSX. 
 
Three of the available emitters (Tribix, SpudSoft and Native) use the Apache POI library to create the Excel files. 
The POI library has two ways to build up the workbook for XLSX - either in memory or streamed to disc. 
For a million rows you really want the streamed to disc approach, otherwise you will need a vast amount of Java heap. 
The problem is that the streamed approach doesn't support a few features (no mixed text formats in cells is one, and with my (SpudSoft) approach no images either) so it tends not to be used by default. 
 
If you are happy with the price I recommend looking at Arctorus, if not have a go with the SpudSoft emitter and if you can't get your million rows in memory let me know and I'll add an option to do the streaming approach (which will have limited features). 
 
Jim