How to remove Limit on export records to excel 5000 lines

kamranshehzad

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.

Christian_Abeln

In NAV2009SP1 this unfortunately is a fixed limit, which cannot be influenced.

kamranshehzad

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,

Troelsh

It's hardcoded in RTC. We will fix this in a later release.

Waldo

Just that you stumble on this page, and are searching for the answer:
viewtopic.php?f=32&t=54417

katie_at_creative

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

We did everything according to this solution <add key=”MaxNoOfXMLRecordsToSend” value=”100000″/> but it still doesn't work

Any other solutions???

trobertst

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