Row limit in XLSX export
Posted 07 September 2011 - 02:22 PM
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)
Posted 09 September 2011 - 10:51 AM
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?
Posted 09 September 2011 - 01:06 PM
Did you bounce you BIRT iServer or BRD Pro?
Posted 09 September 2011 - 01:52 PM
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.
Posted 09 September 2011 - 03:26 PM
Posted 27 September 2011 - 07:04 AM
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.