Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community ForumsBirt Runtime: limited number of rows per XLSX-Sheet
https://www.eclipse.org/forums/index.php/mv/msg/628061/1219731/#msg_1219731
first of all, i use version 4.3.1.
i have a problem when I want to retrieve a birt report from the birt runtime on
my tomcat webserver with the output format xlsx.
The DataSet contains more than 10.000 lines, but there are only 33 rows per a xlsx sheet and
the result set is split in multiple work sheets.
The complete result set is shown in only one work sheet, when I increase the page height
of the master page to (unrealisitc) high numbers. This can not be done, because it should also be possible
to use the same report design for other output formats like PDF (with "normal" page break).
Does anybody have an idea what the problem is, or how can I retrieve xlsx, xls reports with the maximum number of rows?
Thanks in advance]]>Tom Maier2013-12-05T15:15:35-00:00Re: Birt Runtime: limited number of rows per XLSX-Sheet
https://www.eclipse.org/forums/index.php/mv/msg/628061/1220598/#msg_1220598
Kristopher Clark2013-12-12T16:38:37-00:00Re: Birt Runtime: limited number of rows per XLSX-Sheet
https://www.eclipse.org/forums/index.php/mv/msg/628061/1221236/#msg_1221236
With this setting, the xlsx sheet contains 40 rows. (how it should work).
However, when i change the page break interval to 0, the xlsx sheet contains only 33 rows. I think this 33 rows has to do with the page height setting in the master page.
Oddly enought this does not happen with the xls parameter.
The xls sheet contains with the page break interval 0 more than 33 rows.]]>Tom Maier2013-12-17T07:17:09-00:00Re: Birt Runtime: limited number of rows per XLSX-Sheet
https://www.eclipse.org/forums/index.php/mv/msg/628061/1270826/#msg_1270826
In my opinion those two things (page-break & next sheet) are very different and should not be used as synonyms. Excel can handle page-breaks within sheets, so if those page breaks are important to someone (definitly not to me) they should be exported just as that, and not by spliting the data into multiple sheets.
Is there a simple way of getting birt to export all data into a single sheet, without starting to mess with the layout of the report or writing code that adepts the layout depending on how it is generated?
Is there maybe a simple parameter switch I could add to that request to prevent those multiple sheets of beeing generated?
For the moment I'll stick with the default xls emitter, which fortunately doesn't have this bug.]]>Thomas Käfer2014-03-13T15:27:52-00:00Re: Birt Runtime: limited number of rows per XLSX-Sheet
https://www.eclipse.org/forums/index.php/mv/msg/628061/1271096/#msg_1271096
In your case a workaround would be to make use of the "run" servlet instead of "frameset" when a xlsx document is requested:
It is also important to know the behavior of pagination is strongly related to the "layout" property of the report. See this topic
I hope it helps]]>donino donino2014-03-14T08:47:17-00:00Re: Birt Runtime: limited number of rows per XLSX-Sheet
https://www.eclipse.org/forums/index.php/mv/msg/628061/1273016/#msg_1273016
But as I said, I don't really care about those pagebreaks. If the developers care about pagebreaks, they should output them as pagebreaks, but don't confuse pagebreaks with splitting data into multiple sheets.]]>Thomas Käfer2014-03-19T10:07:02-00:00