December 15th, 2012 by Mohamed Aamer

Recently explored the Microsoft Dynamics AX 2012 R2 Interoperability with MS Excel, this post will go through the AX 2012 export function to Excel. Where exploring how end users who used to Excel could easily extract data from DAX to Excel and be able to manipulate this data, and could add more information from DAX without technical experience.

I will go to All Opportunities in Sales & Marketing module.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Export this form to Excel.

 

 

 

 

 

 

 

 

 

 

Excel Client will Open Automatically, now you’re in Excel you can add conditional formats, build charts etc..Move to Dynamics AX Add-In in Excel ribbon, and press Filed Chooser, the available fields will open in left side, double click on the filed you need to add to the report.

 

 

 

 

 

 

 

 

 

User group: DynamicsArabia

Tags: , , , ,
Posted in Microsoft Dynamics, MS Dynamics AX | Comments Off on Microsoft Dynamics AX 2012 – Excel Ad-Hoc Reports
Comments are closed.