Exploring Drill-down SSRS Reports in Dynamics Ax 2012 R3

Drill drown reports in Dynamics Ax 2012 R3 are very vasy. For this purpose, I have to create a new AOT/Static Query AOT. This query is a join between CustTable and SalesTable. I created an Inner Join so only those Customer were selected who have associated Sales Orders. Consider following steps to create a new report: Create a […]

read more

Exploring Drill through Reports 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 clicks on customer account, a new report opens, which contains list of all possible sales Orders. For […]

read more

AX2012 R3- How to Import Contoso Data using Test Data Transfer Tool (Beta)

Pre-requisites: 1-      Download the test data transfer tool from the below mentioned link. https://informationsource.dynamics.com//RFPServicesOnline/Rfpservicesonline.aspx?ToolDocName=Microsoft+Dynamics+AX+2012+Test+Data+Transfer+Tool+(Beta)+-+Updated+7th+Jan+2014%7cQJ4JEM76642V-8-1465 2-      Download demo data for AX2012 R3 from partner source site. Steps:  Extract the demo data files from DynamicsAX2012R3DemoData.exe to a specific location. The output folder will contain the files of following extension types: .OUT—– data file that contains metadata for […]

read more