NAV 2009 RTC Report Export to Excel more than 65536 Records

dipakpatel2505dipakpatel2505 Member Posts: 169
edited 2012-06-21 in NAV Three Tier
Hello All,

I am running RTC report for Whole Year and it have more than 65536 records.

Configuration : NAV 2009 R2 RTC,MS SQL2008 R2,Microsoft Office 2007

I want to use default export to excel functionality of RTC Report but I am not able to do and it gives me following error :


Export Error
An error occurred during local report processing.
An error occurred during rendering of the report.
An error occurred during rendering of the report.
Excel Rendering Extension : Number of rows in the Excel sheet exceeded the limit of 65536 rows.
OK


Any help is appriciated. Is there any workaround/hotfix to solve this problem ?

Comments

  • marcoau18marcoau18 Member Posts: 9
    Hello All,

    I am running RTC report for Whole Year and it have more than 65536 records.

    Configuration : NAV 2009 R2 RTC,MS SQL2008 R2,Microsoft Office 2007

    I want to use default export to excel functionality of RTC Report but I am not able to do and it gives me following error :


    Export Error
    An error occurred during local report processing.
    An error occurred during rendering of the report.
    An error occurred during rendering of the report.
    Excel Rendering Extension : Number of rows in the Excel sheet exceeded the limit of 65536 rows.
    OK


    Any help is appriciated. Is there any workaround/hotfix to solve this problem ?

    65536 is the maximum row records can output in Excel 2007
    You can
    - Use a newer version of excel like 2010 which has larger range (but you may still exceed it :lol: )
    - Or Filter the no. of record before export to excel \:D/
  • dipakpatel2505dipakpatel2505 Member Posts: 169
    Hello Marcoau18,

    Thanks for your reply.

    I would like to inform you that Excel 2007 contains "1048576" rows so it should be possible to export to excel for 1048576 rows but I am not able to do it.

    Does it Navision RTC Report Limitation that We cannot export more than 65536 rows ?
  • marcoau18marcoau18 Member Posts: 9
    Hello Marcoau18,

    Thanks for your reply.

    I would like to inform you that Excel 2007 contains "1048576" rows so it should be possible to export to excel for 1048576 rows but I am not able to do it.

    Does it Navision RTC Report Limitation that We cannot export more than 65536 rows ?

    Just checked that RTC set the buffer size as 65536 rows ..... need to wait for fix. [-(
  • mohana_cse06mohana_cse06 Member Posts: 5,503
    Did you try by increasing MaxUploadSize in Customsettings.config file?

    Is your report working in Classic?
  • manisharma31manisharma31 Member Posts: 285
    If you check codeunit 424 there is a function called CheckNoOfRows, where if your data in rows exceeds 65000 then you get the error.

    You should try to filter your data which is right now a solution if you want to stick to standards.
    Regards,
    Manish
  • hgnamushgnamus Member Posts: 8
    I capture This Error too. Please help me !
  • thegunzothegunzo Member Posts: 274
    I am sorry, you will need a customized solution. For example look here -> http://www.dynamics.is/?p=831
    ________________________________
    Gunnar Gestsson
    Microsoft Certified IT Professional
    Dynamics NAV MVP
    http://www.dynamics.is
    http://Objects4NAV.com
Sign In or Register to comment.