You’re offline. This is a read only version of the page.
120
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
The code is same in NAV2013R2 also.
Set debugger and check what is the value of ExcelVersion.
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..
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..
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (