Jump to content

BIRT Developer Center
Download


Photo
- - - - -

Row limit in XLSX export


  • Please log in to reply
8 replies to this topic

#1 M_Terk

M_Terk

    Member

  • Members
  • PipPip
  • 16 posts

Posted 07 September 2011 - 02:22 PM

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

#2 averma

averma

    Senior Member

  • Members
  • 713 posts

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

Ashwini

Follow me on Twitter
Read my Blog BIRT Rocks!


#3 M_Terk

M_Terk

    Member

  • Members
  • PipPip
  • 16 posts

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

#4 averma

averma

    Senior Member

  • Members
  • 713 posts

Posted 09 September 2011 - 12:56 PM

Did you bounce you BIRT iServer or BRD Pro?

Ashwini

Follow me on Twitter
Read my Blog BIRT Rocks!


#5 M_Terk

M_Terk

    Member

  • Members
  • PipPip
  • 16 posts

Posted 09 September 2011 - 01:06 PM

Did you bounce you BIRT iServer or BRD Pro?


The server

MT

#6 averma

averma

    Senior Member

  • Members
  • 713 posts

Posted 09 September 2011 - 01:08 PM

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?

Ashwini

Follow me on Twitter
Read my Blog BIRT Rocks!


#7 M_Terk

M_Terk

    Member

  • Members
  • PipPip
  • 16 posts

Posted 09 September 2011 - 01:52 PM

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

#8 averma

averma

    Senior Member

  • Members
  • 713 posts

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)

Ashwini

Follow me on Twitter
Read my Blog BIRT Rocks!


#9 M_Terk

M_Terk

    Member

  • Members
  • PipPip
  • 16 posts

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.

MT