SSRS DrillThrough Reports in Ax 2012

Hi Friends, today I would like to share my learning related to SSRS DrillThrough reports, Please follow the below steps to achieve the DrillThrough functionality.

1.  Open the report for which DrillThrough functionality needs to be applied.
2.  Create a new data method as shown below

3. Rename the newly added data method to PurchaseOrder

4. Open the data method PurchaseOrder and we will find the newly added Business logic project added to the same solution as show below.

Method Content:

X++ code for getting "BusinessUnit" Address based on "OmOperatingUnitNumber" & "OmOperatingUnitType" in D365 F&O || Ax 2012

Hi everyone, 

The blow code snippet is used to get the Business unit address based on OmOperationUnitNumber and OmOperationUnitType.

static void getBusinessUnitaddress(Args _args)
{
    OMOperatingUnit   operatingUnits;

    select firstOnly * from operatingUnits
        where operatingUnits.OMOperatingUnitNumber  == "047" && // operating unit number
        operatingUnits.OMOperatingUnitType          == OMOperatingUnitType::RetailChannel; // operating type

    info(strFmt("%1",operatingUnits.primaryAddress()));
}

Proud To Be a DAX Developer :-) 

DIXF: Could not load the assembly ‘Microsoft.Dynamics.AX.framework.Tools.PreviewGrid' in Ax 2012

Error

Could not load the assembly ‘Microsoft.Dynamics.AX.framework.Tools.PreviewGrid’

DIXF:"Assembly containing type Microsoft.Dynamics.AX.framework.Tools.DMF.ServiceProxy.DmfEntityProxy is not referred" in AX 2012

​Error

"Assembly containing type Microsoft.Dynamics.AX.framework.Tools.DMF.ServiceProxy.DmfEntityProxy is not referred"