Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » BIRT Report Development(XLS Tab Splitting Issue)
BIRT Report Development [message #1576663] Wed, 21 January 2015 12:52 Go to next message
Pradeep Raju is currently offline Pradeep RajuFriend
Messages: 8
Registered: January 2015
Junior Member

Hi All,

I am using Eclipse Luna 4.4.0 version for BIRT Report development. I have an issue when I export a report to XLS. If the data is more then 10,344 rows, it will automatically split to next tab. I am having data approx. 55829 rows, so it will split 5 tab in XLS sheet. I need all data in single sheet (i.e all 55829 rows in single tab).


Thanks,
Pradeep D.

Report message to a moderator

Re: BIRT Report Development [message #1577074 is a reply to message #1576663] Wed, 21 January 2015 17:53 Go to previous messageGo to next message
Jesse Freeman is currently offline Jesse FreemanFriend
Messages: 184
Registered: January 2015
Senior Member
Which excel emitter are you utilizing?

Report message to a moderator

Re: BIRT Report Development [message #1577920 is a reply to message #1577074] Thu, 22 January 2015 05:05 Go to previous messageGo to next message
Pradeep Raju is currently offline Pradeep RajuFriend
Messages: 8
Registered: January 2015
Junior Member

Hi Jesse Freeman,

Thanks for your reply. i am using the default version.

"E:\Eclipse\Luna\eclipse\plugins\uk.co.spudsoft.birt.emitters.excel_4.4.0.v201405191524".


Actually i don't know how to find out which excel emitter version i am using. In case above one is wrong please tell me the steps, how to find out "excel emitter version".

Thanks,
Pradeep D.

Report message to a moderator

Re: BIRT Report Development [message #1580171 is a reply to message #1577920] Fri, 23 January 2015 10:25 Go to previous messageGo to next message
Pradeep Raju is currently offline Pradeep RajuFriend
Messages: 8
Registered: January 2015
Junior Member

Hi Jesse Freeman,

Please reply me as soon as possible.

Thanks,
Pradeep D

Report message to a moderator

Re: BIRT Report Development [message #1588843 is a reply to message #1580171] Wed, 28 January 2015 05:07 Go to previous messageGo to next message
Pradeep Raju is currently offline Pradeep RajuFriend
Messages: 8
Registered: January 2015
Junior Member

Hi All,

Can any one give a suggestions how to solve this issue. Please help me.

Thanks,
Pradeep D.

Report message to a moderator

Re: BIRT Report Development [message #1589823 is a reply to message #1576663] Wed, 28 January 2015 17:28 Go to previous messageGo to next message
Suraj Singh is currently offline Suraj SinghFriend
Messages: 1
Registered: January 2015
Junior Member
There's a new third-party integration in Eclipse that dynamically prepares (integrates, masks, etc.) data for BIRT reports. The IRI Data Source provider (using ODA), exposed in the Data Tools Platform (DTP) plug-in for Eclipse, ingests the output of CoSort, FieldShield or other IRI software job scripts in real time.

When you run a BIRT report with those columns from the IRI data source specified, the IRI product will run in the background to prepare the raw data at reporting time. Both the back-end data prep and the BIRT report are designed and run in the same Eclipse plug-in, the IRI Workbench.

Report message to a moderator

Re: BIRT Report Development [message #1602584 is a reply to message #1589823] Thu, 05 February 2015 17:14 Go to previous messageGo to next message
Jesse Freeman is currently offline Jesse FreemanFriend
Messages: 184
Registered: January 2015
Senior Member
Sorry for the delayed response.

When you are selecting to export to XLS, which specific value are you selecting? Does it have Spudsoft in the name?
Are you generating to XLS directly from the designer or are you viewing the report in the web viewer before exporting to XLS?

Report message to a moderator

Re: BIRT Report Development [message #1605007 is a reply to message #1602584] Sat, 07 February 2015 07:00 Go to previous messageGo to next message
Pradeep Raju is currently offline Pradeep RajuFriend
Messages: 8
Registered: January 2015
Junior Member

Hi Jesse Freeman,

It's ok and thanks for your reply.
we are viewing the report in the web viewer before exporting to XLS.

Thanks,
Pradeep D.

Report message to a moderator

Re: BIRT Report Development [message #1608988 is a reply to message #1605007] Mon, 09 February 2015 22:21 Go to previous messageGo to next message
Jesse Freeman is currently offline Jesse FreemanFriend
Messages: 184
Registered: January 2015
Senior Member
You may be running into something I saw recently. As of version 4.3 of BIRT there is a default max page break limit of 10k rows per page by default. This can be over ridden in the beforeFactory of the report design.

For example, to adjust the max page break to 15k instead of 10k:
reportContext.getAppContext().put("MAX_PAGE_BREAK_INTERVAL", 15000);


Take a look at this bug thread for reference: https://bugs.eclipse...g.cgi?id=413607

Report message to a moderator

Re: BIRT Report Development [message #1609816 is a reply to message #1608988] Tue, 10 February 2015 11:04 Go to previous messageGo to next message
Pradeep Raju is currently offline Pradeep RajuFriend
Messages: 8
Registered: January 2015
Junior Member
Hi Jesse Freeman,

Thanks for your reply. I tried your script in before Factory, after using this script my report is not working. I have attached the image what i am getting to ran a report. Also when i run my report, data having more then 2.5 lakhs rows.


Thanks,
Pradeep D.

Report message to a moderator

Re: BIRT Report Development [message #1610398 is a reply to message #1609816] Tue, 10 February 2015 19:32 Go to previous messageGo to next message
Jesse Freeman is currently offline Jesse FreemanFriend
Messages: 184
Registered: January 2015
Senior Member
Of the 2.5 lakh rows, how many rows are you attempting to export to a single page?
Do you see any errors in the designers log or in the console output in Chrome?

Report message to a moderator

Re: BIRT Report Development [message #1611123 is a reply to message #1610398] Wed, 11 February 2015 06:51 Go to previous messageGo to next message
Pradeep Raju is currently offline Pradeep RajuFriend
Messages: 8
Registered: January 2015
Junior Member

Hi Jesse Freeman,

I want all the 2.5 lakhs rows in single sheet.
No error in the designers log and the console output in Chrome is 'Inspected target crashed'.
But if use this script "reportContext.getAppContext().put("MAX_PAGE_BREAK_INTERVAL", 15000);"
my report is not working. I already attached that screen shot in previous reply. If i not use this script my report run correctly and i can export a XLS sheet. In that sheet totally 26 tabs are there. So i need all the rows in single sheet.


Thanks,
Pradeep D.

Report message to a moderator

Re: BIRT Report Development [message #1690619 is a reply to message #1611123] Mon, 30 March 2015 06:39 Go to previous messageGo to next message
Pradeep Raju is currently offline Pradeep RajuFriend
Messages: 8
Registered: January 2015
Junior Member


Hi Jesse Freeman,

Please do the needful as soon as possible.

Thanks,
Pradeep D.

Report message to a moderator

Re: BIRT Report Development [message #1690881 is a reply to message #1690619] Tue, 31 March 2015 18:20 Go to previous message
Jesse Freeman is currently offline Jesse FreemanFriend
Messages: 184
Registered: January 2015
Senior Member
Can you attach a sample report with a flat file data source that reproduces the issue you are seeing in Chrome when setting the MAX_PAGE_BREAK_INTERVAL?

I cannot reproduce the behavior you are describing.

Report message to a moderator

Previous Topic:Calculate the exact height of a cell on birt
Next Topic:How can I customize the ViewerServlet's "BIRT Report Viewer" report label?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 21:33:53 GMT 2024

Powered by FUDForum. Page generated in 0.04002 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly