Wednesday 21 May 2014

EP: Export data in enterprise portal page to excel (Dynamic)


Hello every oneJ!

This article is to export data in enterprise portal page to excel (Dynamic) :

 

In the recent time we have faced an issue while we tried to export data to excel using dynamic option. For your information there are two ways to export data 1. Static and 2. Dynamic (Differences we are not going to discuss in this article).

The data was not coming into excel we can see only columns headings in the first line.

(In Dynamic excel export the business log will run from the local client and the data is fetched from AOS)

This is due to settings on the Microsoft Excel à Dynamics AXàOptions
 



Here the Server name and Port should be the same as your AOS server name and port respectively.

Hence by changes these settings our issue got resolved. Hope this will help youJ!

Update NuGet package to new MS D365FO version

1. Import the NuGet package files from LCS for that particular version please take the PU version files only. a. Goto LCS-->Asset Libra...