Inside Dynamics AX

On particular table add DefaultDimension field and make the relation such that: On the Particular forms CalssDeclearation write following code:  ----------------------------------------------------------------------------- DimensionDefaultingController   dimensionDefaultingController; ------------------------------------------------------------------------------ Override the forms Init method and add following lines of code: ----------------------------------------------------------------------------------------------------------------------     dimensionDefaultingController = DimensionDefaultingController::constructInTabWithValues(     true, true, true/*financialsDimensionsEnabled*/, 0, this,<Tab Page Name> , "@SYS138491");     dimensionDefaultingController.parmAttributeValueSetDataSource(<dataset name_ds>,         fieldStr(<table name>, <field name>)); -----------------------------------...

To deploy a specific report, enter the name of the report. For example, to deploy the CustTransList report, enter the following command: Microsoft Dynamics AX Management Shell: *************************************** Publish - AXReport  - ReportName CustTransList *************************************** To deploy two or more specific reports, enter the names of the reports. For example, to deploy the CustTransList and CustTransOpenPerDate reports, enter the following command: Microsoft Dynamics AX Management Shell: ********************************************************** Publish - AXReport - ReportName CustTransList, CustTransOpenPerDate ***************************************************************** To deploy all reports, enter the following command: Microsoft Dynamics AX Management Shell: **************************** Publish - AXReport –ReportName * *******************************

In this post we will be creating a Query having multiple Data sources which be be further used in some other places such as forms, parts, Reports etc. In this scenario we will be having 3 different tables i.e. Students, StudentsCourses and Courses table. We will be creating a query containing these 3 tables as data source in a specific way such that their relation is maintained. Below are the following three tables: Now let's create our desired query: Go to Queries Node in the AOT. Right Click on Query and Select New Query. Rename the Query to "DemoQuery".  We are all done with creating our Query.  Now we will be adding Data Sources to our Query. Open a new AOT (CTRL+D) and navigate to the Data Dictionary --> Tables and select the required table. in this case we will select Students Table and drag it on the Data Source Node of our Query. Expand the Students node and Set the Fields Dynamic Property to Yes. This will add all the Ta...

Reference:  https://msdn.microsoft.com/EN-US/library/bb278121.aspx The Application Object Tree (AOT) provides a graphical interface for creating queries. These are known as static queries. When a query is created using the AOT, the SysQuery and SysQueryRun classes are used behind the scenes. In Microsoft Dynamics AX, static queries are located in the  Queries  node and contain the following primary sub-nodes: Methods Data Sources Dependent Objects Composite Query Methods The  Methods  node displays all the methods available from a query. In this node you can add a new method to a query. You can also override methods on the  QueryRun  system class and add your own code to class methods inherited from the  QueryRun  class. Only new methods and overridden methods appear in the  Queries  node except for the  classDeclaration  method which is always present. To add a new method: Navigate to the...