I am trying to export content of a long report (400 pages). When selecting XLSX as the format in the export content option, the resulting file seems to be trunkated to 8000 rows. I thought Excell 2007 allows 16000 rows.
Can anyone give me an idea of how I can export long reports to Excel? I am running iServer 11 Service Pack 1 (Build 110C110326)
M. Terk
Page 1 of 1
Row limit in XLSX export
why is my data beings trunkated at 8000 rows
Rate Topic:
MultiQuote
#2
averma 
- Senior Member
-
- Group: Administrators
- Posts: 713
- Joined: 08-August 07
Posted 08 September 2011 - 11:06 AM
Hi M. Terk,
There is a default limit of 200 on the maximum number of pages that can be exported from the report, but this can be configured:
http://www.birt-exch...t-can-exported/
Ashwini
There is a default limit of 200 on the maximum number of pages that can be exported from the report, but this can be configured:
http://www.birt-exch...t-can-exported/
Ashwini
#3
M_Terk
- Member
-
- Group: Members
- Posts: 14
- Joined: 08-February 08
Posted 09 September 2011 - 10:51 AM
Ashwini,
I tried that but the viewer still cuts it off at the 8000 lines. If I try the same thing from the designer the emitter has no problem with producing the required line numbers, but the viewer does not. Are there any other configuration parameters I need to change?
Thanks,
Michael Terk
I tried that but the viewer still cuts it off at the 8000 lines. If I try the same thing from the designer the emitter has no problem with producing the required line numbers, but the viewer does not. Are there any other configuration parameters I need to change?
Thanks,
Michael Terk
#8
averma
- Senior Member
-
- Group: Administrators
- Posts: 713
- Joined: 08-August 07
Posted 09 September 2011 - 03:26 PM
This is very strange, can you try with the latest version (11 sp2) and see if you can recreate this issue? Also out of curiosity have you tried this in BRD Pro? (make sure to make adjustments to ALLOW_EXPORT_PAGE_LIMIT as mentioned in my article and restart BRD Pro before you export report)
#9
M_Terk
- Member
-
- Group: Members
- Posts: 14
- Joined: 08-February 08
Posted 27 September 2011 - 07:04 AM
averma, on 09 September 2011 - 04:26 PM, said:
This is very strange, can you try with the latest version (11 sp2) and see if you can recreate this issue? Also out of curiosity have you tried this in BRD Pro? (make sure to make adjustments to ALLOW_EXPORT_PAGE_LIMIT as mentioned in my article and restart BRD Pro before you export report)
The issue was solved by talking to Actuate support. They had us clear some jsp cache on the server and after that we were able to see all of the rows.
MT
Page 1 of 1
