Drill drown reports in Dynamics Ax 2012 R3 are very Easy. For this purpose I have to create a new AOT/Static Query AOT. This query is join between CustTable and SalesTable. I want to create Inner Join so Only those Customer came who have Sales Orders. Consider following Steps to create A new report Create a new Query with Name “DyWorldCustSales” Drop or add Data Source with … [Read more...] about Exploring Drill-down SSRS Reports in Dynamics Ax 2012 R3.
Archives for June 2014
Exception has been thrown by the target of invocation in dynamics Ax. I got this error on my VM. On closely examination, I found that In AOT Data dictionary is not synchronize with Sql Server . I perform following steps to resolve this error • Right click on data Dictionary and synchronize the data Dictionary. • Right click on AOT and compile it, it step take longer … [Read more...] about Exception has been thrown by the target of invocation in dynamics Ax
In Dynamics AX 2012 Reports can be called from Class, and it is import part of MVC pattern implementation for reports The report created from following link is called from controller class http://tech.alirazazaidi.com/exploring-drill-through-reports-in-dynamics-ax-2012-r3/ Create a new class and extends it with “SRSReportRunController” class. Add New method, and update it … [Read more...] about Exploring Report Controller class in dynamics AX 2012 R3
Creating basic drill through reports in Dynamics Ax 2012 R3 is really simple. Consider following scenario where we have to show the list of customer and their sales Orders in particular legal Entity. In this report when User click on customer account, a new report open which contains list of all possible sales Order. For this Purpose I created two Static/AOT queries. First … [Read more...] about Exploring Drill through Reports in Dynamics Ax 2012 R3.
Today while deploying Dynamics AX 2012 R3 SSRS reports on window 7 I got following when I run Report deployment command on publish-AXReport -ReportName *. “A call to the Microsoft Dynamics AX SRSFramework Service service failed. An existing connection was forcibly closed by the remote host.“. I perform following steps to solve this problem. 1. Stop reporting … [Read more...] about A call to the Microsoft Dynamics AX SRSFramework Service failed.