Row limit in XLSX export

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

Find more posts tagged with

Comments

averma

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-exchange.org/org/devshare/deploying-birt-reports/1411-limit-the-number-of-pages-that-can-exported/

Ashwini

M_Terk

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

averma

Did you bounce you BIRT iServer or BRD Pro?

M_Terk

<blockquote class='ipsBlockquote' data-author="'averma'" data-cid="82547" data-time="1315601813" data-date="09 September 2011 - 01:56 PM">
Did you bounce you BIRT iServer or BRD Pro? </blockquote>
 
The server 
 
MT

averma

I have tried this at my end for a report that had more than 35K rows and it worked. What version of BIRT iServer are you using?

M_Terk

I am running iServer 11 Service Pack 1 (Build 110C110326).

I am able to see all 400 pages of the report in viewer but when i select export content and choose XLSX I get only 8001 rows.

MT

averma

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)

M_Terk

<blockquote class='ipsBlockquote' data-author="'averma'" data-cid="82556" data-time="1315610781" data-date="09 September 2011 - 04: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) </blockquote>
 
 
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