NAV 2009 RTC Report Export to Excel more than 65536 Records

dipakpatel2505

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 ?

marcoau18

dipakpatel2505 wrote:

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 )
- Or Filter the no. of record before export to excel \:D/

dipakpatel2505

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 ?

marcoau18

dipakpatel2505 wrote:

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_cse06

Did you try by increasing MaxUploadSize in Customsettings.config file?

Is your report working in Classic?

manisharma31

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.

hgnamus

I capture This Error too. Please help me !

thegunzo

I am sorry, you will need a customized solution. For example look here -> http://www.dynamics.is/?p=831