Export To Excel > 5000 Error
since2002
Member Posts: 25
There are a few posts regarding this issue but I cannot seem to find a definitive answer that was worked for everyone. We are trying to overcome the restriction of the 5000 row limit when exporting data to excel from a page. I have inserted the below line with different values like 6000, 50000 etc but the error persists at 5000.
We are at build level 32012.0. I did see a hotfix related to build level 32146. Does the "add key" fix below only apply to build 32146 or higher?
We are updating the clientusersettings.config on the individual PC.
Is there another place where this value should be changed or additional steps?
You can adjust that number in clientusersettings.config :
<add key="MaxNoOfXMLRecordsToSend" value="5000"/>
We are at build level 32012.0. I did see a hotfix related to build level 32146. Does the "add key" fix below only apply to build 32146 or higher?
We are updating the clientusersettings.config on the individual PC.
Is there another place where this value should be changed or additional steps?
You can adjust that number in clientusersettings.config :
<add key="MaxNoOfXMLRecordsToSend" value="5000"/>
0
Comments
-
Did you follow the blogs instructions found here?:
http://blogs.msdn.com/b/nav/archive/201 ... terop.aspx
or this one?
http://navgeek.blogspot.com/2013/05/how ... excel.html
Last but not least:
viewtopic.php?f=32&t=57378&p=2761180 -
I tried the "Or this One" and the "Last but not least" method so i'll have to assume the hotfix is required before doing the <add key="MaxNoOfXMLRecordsToSend" value="10000"/>0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions