mibuso.com

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

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.

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

Is your report working in Classic?

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.

I capture This Error too. Please help me !

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