How to remove Limit on export records to excel 5000 lines

kamranshehzad
kamranshehzad Member Posts: 165
edited 2014-10-06 in NAV Three Tier
I want to remove this limit as RTC client doesn't allow you to export more than 5000 lines at one time from pages.
this is causing issues as there isn't any excel kind of controls to get quick sums and if we export it then it becomes more difficult to do sums etc.;

any idea?

thanks.
KS

Answers

  • Christian_Abeln
    Christian_Abeln Member, Microsoft Employee Posts: 42
    In NAV2009SP1 this unfortunately is a fixed limit, which cannot be influenced.
    “This posting is provided "AS IS" with no warranties, and confers no rights.”

    Christian Abeln
    Program Manager Microsoft
    Dynamics NAV
    blogs.msdn.com/cabeln/
  • kamranshehzad
    kamranshehzad Member Posts: 165
    I can see in classic client that you can go to tools > options and set the Max. no. of XML records to send.. but this doesn't work for rtc..

    is it hardcoded in database or any code unit? or its hard coded in rtc??

    regards,
    KS
  • Troelsh
    Troelsh Member, Microsoft Employee Posts: 79
    It's hardcoded in RTC. We will fix this in a later release.

    Troels Bent Hansen
    Senior Program Manager
    Microsoft Dynamics NAV

    ****** This posting is provided "AS IS" with no warranties, and confers no rights ******
  • Waldo
    Waldo Member Posts: 3,412
    Just that you stumble on this page, and are searching for the answer:
    viewtopic.php?f=32&t=54417
    :mrgreen:

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • katie_at_creative
    katie_at_creative Member Posts: 42
    This issue is now resolved by applying build 32146 or later and adding a key to the clientusersettings.config file.

    <add key="MaxNoOfXMLRecordsToSend" value="XXXX" />
  • winerry
    winerry Member Posts: 1
    We did everything according to this solution <add key=”MaxNoOfXMLRecordsToSend” value=”100000″/> but it still doesn't work

    Any other solutions???
  • trobertst
    trobertst Member Posts: 1
    Applying the <add key=”MaxNoOfXMLRecordsToSend” value=”100000″/> works on the server for me when logged onto the server. When I launch Citrix, it doesn't work.

    Where is the origin of the clientusersettings.config that is created for the "User Name" profiles created on the Citrix Server. I have added the key to the "All Users" path on the server but that hasn't fixed the problem.

    Thanks,

    Tom Roberts
    tom.roberts@knk.com

Categories