Eclipse Community Forums: BIRT » BIRT:: Overflow records in excel (xls) to next tabs

Home » Archived » 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

Eclipse User

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] by 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

Eclipse User

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

Re: BIRT:: Overflow records in excel (xls) to next tabs [message #1095211 is a reply to message #1078510]

Mon, 26 August 2013 15:51

Eclipse User

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

Eclipse User

Sounds good. Let me know.

Re: BIRT:: Overflow records in excel (xls) to next tabs [message #1096748 is a reply to message #1095967]

Wed, 28 August 2013 16:23

Eclipse User

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

Eclipse User

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.

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:

-=] Back to Top [=-

Current Time: Mon Jul 28 09:36:33 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter