mibuso.com

Microsoft Business Solutions online community
It is currently Thu Sep 18, 2014 3:35 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 8 posts ] 
Author Message
 Post subject: NAV 2009 RTC Report Export to Excel more than 65536 Records
PostPosted: Mon Apr 02, 2012 2:22 pm 
Offline

Joined: Tue Sep 23, 2008 1:30 pm
Posts: 116
Country: India (in)
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 ?


Attachments:
Error.jpg
Error.jpg [ 21.42 KiB | Viewed 2688 times ]
Top
 Profile E-mail  
 
 Post subject: Re: NAV 2009 RTC Report Export to Excel more than 65536 Reco
PostPosted: Tue Apr 03, 2012 6:38 am 
Offline

Joined: Tue Jan 23, 2007 11:15 am
Posts: 8
Location: Hong Kong
Country: Hong Kong (hk)
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 :lol: )
- Or Filter the no. of record before export to excel \:D/


Top
 Profile  
 
 Post subject: Re: NAV 2009 RTC Report Export to Excel more than 65536 Reco
PostPosted: Tue Apr 03, 2012 8:15 am 
Offline

Joined: Tue Sep 23, 2008 1:30 pm
Posts: 116
Country: India (in)
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 ?


Top
 Profile E-mail  
 
 Post subject: Re: NAV 2009 RTC Report Export to Excel more than 65536 Reco
PostPosted: Tue Apr 03, 2012 8:43 am 
Offline

Joined: Tue Jan 23, 2007 11:15 am
Posts: 8
Location: Hong Kong
Country: Hong Kong (hk)
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. [-(


Top
 Profile  
 
 Post subject: Re: NAV 2009 RTC Report Export to Excel more than 65536 Reco
PostPosted: Tue Apr 03, 2012 8:53 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Sep 02, 2008 8:37 am
Posts: 4594
Location: Hyderabad
Country: India (in)
Did you try by increasing MaxUploadSize in Customsettings.config file?

Is your report working in Classic?

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav


Top
 Profile  
 
 Post subject: Re: NAV 2009 RTC Report Export to Excel more than 65536 Reco
PostPosted: Wed Apr 04, 2012 7:02 pm 
Offline

Joined: Mon Oct 06, 2008 2:05 pm
Posts: 267
Country: India (in)
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


Top
 Profile E-mail WWW  
 
 Post subject: Re: NAV 2009 RTC Report Export to Excel more than 65536 Reco
PostPosted: Tue Jun 19, 2012 6:41 am 
Offline

Joined: Tue Aug 02, 2011 11:52 am
Posts: 7
Country: Vietnam (vn)
I capture This Error too. Please help me !


Top
 Profile E-mail  
 
 Post subject: Re: NAV 2009 RTC Report Export to Excel more than 65536 Reco
PostPosted: Thu Jun 21, 2012 9:59 pm 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Mon Apr 04, 2005 3:49 pm
Posts: 243
Location: Sauðárkrókur
Country: Iceland (is)
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


Top
 Profile E-mail WWW  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 8 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: Exabot [Bot], Google [Bot] and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: