Notifications
Announcements
No record found.
Hi All,
Can you please let me know , i have required to fetch data from AX and EXPORT to excel through CODE and need to save in particular directory with file name.
Criteria --
Dialog --
From date
To date
Vendor code
Vendor group
Please give me more shed on this.
Thanks!
First of all, why do you want to write custom code for it? Doesn't DIXF already have all the features?
Customer wants report (NOT SSRS) in excel directly. which saved in particular directory.
I preferred Job or class to do this...
Please give me more shed on this
Hi Arpan,
for lookup field job will not work better to use class to generate excel.
Sure, i will use class
Can you please give me the sample code please
What exactly do you mean by a report? You said what it shouldn't be (= built with SSRS), but not what it should.
Also note that you didn't answer my first question.
They gave the report format. that i need to show directly in excel.
means when user run this report from menu item, it will open dialog , then user will fill from date and to date and press ok.
then customer wants those data in to EXCEL DIRECTLY and save in particular directory.
i hope you understand now
Then your first step should be evaluation how you can build the report. Maybe you can use SSRS, maybe Excel Add-In, maybe you can design an Excel template and populate it with data on some way, maybe you need building the whole document in code and so on.
If - which is not clear at all at the moment - you find out that you must do it all from code, choose the API and then use your favorite search engine to learn how to use it. Consider especially SysExcelApplication (X++) and EPPlus (.NET). for instance.
If you run into a problem, come here and explain your particular problem.
Please go to this link to have overview on code www.theaxapta.com/.../how-to-readwrite-excel-file-through-x.html
Yes martin,
i preferred sysexcelapplication
please give me the sample code
Below link may help you in detail community.dynamics.com/.../dynamics-ax-code-to-read-write-data-to-excel
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 451 Most Valuable Professional
André Arnaud de Cal... 428 Super User 2025 Season 2
BillurSamdancioglu 239 Most Valuable Professional
