Notifications
Announcements
No record found.
Since MS Excel 2007 has capability of taking 10L records but from NAV 2013 report viewer unable to transfer more than 65000 rows.
*This post is locked for comments
in Codeunit 424 function CheckNoOfRows, NAV checks whether excel version is >= 12 and number of rows is greater than 65000.
Check what is going wrong in that code..
Code written as below
IF ExcelVersion = '' THEN
IF NOT ISCLEAR(xlApp) THEN
ExcelVersion := COPYSTR(xlApp.Version,1,MAXSTRLEN(ExcelVersion));
IF (ExcelVersion < '12.0') AND (NoOfRows > 65000) THEN
ERROR(Text032,65000,AnalysisView.FIELDCAPTION("Date Compression"),AnalysisView.TABLECAPTION);
I need to understand why such code is there if both are MS product and MS Excel 2007 support more than 10L rows. Is there any limitation isn NAV 2013 and what excatly done in NAV 2013 R/2 to resolve such issue.
Is any separate patch available to resolve this?
Thanks in advance..
The code is same in NAV2013R2 also.
Set debugger and check what is the value of ExcelVersion.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
