Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » BIRT:: Overflow records in excel (xls) to next tabs(BIRT 2.6 - xls output has a limitation of 65536 rows, can it be emitted to next tabs ?)
BIRT:: Overflow records in excel (xls) to next tabs [message #1076068] Tue, 30 July 2013 12:50 Go to next message
Eclipse Beginner is currently offline Eclipse Beginner
Messages: 23
Registered: September 2011
Junior Member
Hi,

I am using BIRT 2.6, have no problems in moving over to 4.3.
Problem is I have huge datasets, and the records are overflowing resulting in errors and failures. I am wondering if we have anything that can make it flow over to next tabs. I cannot move to xlsx because xls that BIRT generate is xml based so it is serving me as an interface down to other apps and also as a direct readable layout.

TIA
J

[Updated on: Tue, 30 July 2013 12:50]

Report message to a moderator

Re: BIRT:: Overflow records in excel (xls) to next tabs [message #1078510 is a reply to message #1076068] Sat, 03 August 2013 01:10 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1546
Registered: July 2009
Senior Member

If you can upgrade to BIRT 4.3, there is XLSX support. If you cannot, you might try using the emitter that's used in the latest version with 2.6:

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

If that doesn't work, you could always try the old Tribix emitter:

http://www.birt-exchange.org/devshare/_/designing-birt-reports/tribix-extended-emitters-for-birt-r349


Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: BIRT:: Overflow records in excel (xls) to next tabs [message #1095211 is a reply to message #1078510] Mon, 26 August 2013 15:51 Go to previous messageGo to next message
Eclipse Beginner is currently offline Eclipse Beginner
Messages: 23
Registered: September 2011
Junior Member
Thanks Michael, guess that is what I am going to try now.
Re: BIRT:: Overflow records in excel (xls) to next tabs [message #1095967 is a reply to message #1095211] Tue, 27 August 2013 15:43 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1546
Registered: July 2009
Senior Member

Sounds good. Let me know.

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: BIRT:: Overflow records in excel (xls) to next tabs [message #1096748 is a reply to message #1095967] Wed, 28 August 2013 16:23 Go to previous messageGo to next message
Eclipse Beginner is currently offline Eclipse Beginner
Messages: 23
Registered: September 2011
Junior Member
Well, for one it worked with 4.3
But looks like when I configure the 3.7 or older design to put a page break on any group level then it is not identified by the 3.7 engine but the 4.3 does identify it and puts page break pretty much as expected i.e. moves the groups over to next tabs. I am not clear on the usage of page interval though.
Do you think this should be done by 3.7 engine as well ?
Re: BIRT:: Overflow records in excel (xls) to next tabs [message #1096958 is a reply to message #1096748] Thu, 29 August 2013 00:07 Go to previous message
Michael Williams is currently offline Michael Williams
Messages: 1546
Registered: July 2009
Senior Member

With 3.7, the SpudSoft emitter is not in there, so you'd have to go to the link above, download the spudsoft emitter and install it into BIRT 3.7. Without doing this, the out-of-the-box XLS emitter will not page break across sheets.

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Previous Topic:not able to pass the selected x-axis value in case of bar chart - based on value series
Next Topic:Jar doesnot terminate when there is a heap space error while using birt runtime
Goto Forum:
  


Current Time: Wed Jul 23 14:18:29 EDT 2014

Powered by FUDForum. Page generated in 0.03314 seconds