Dynamics AX Techie

Drill Down Reports: Here we are going to do Drill down reports in ssrs - AX 2012 1.Create new query in AOT Named as Custtransaction. 2.Add CustTrans as datasource. 3.Set Dynamic  = yes in field property. 4.Open Visual studio 2010 5.Create new report > In property change the name to CustTrans 6.Add new dataset with below properties  Datasource = Dynamics AX  Datasource Type = Query            In query property select the query (CustList) 7.Create Precision Design. 8.Select Table in report tools. 9.Select Voucher,Transdate,Invoiceid,Amount currency Now we need to group the data based on the account number. Follow the below steps:  Adding Group    Select the row which we want to hide and show > Right click > Row visibility.    Select hide button to hide the row details.   Now we can expand and we can see the Customer details.   Same way we can group coloumn wise. 

\Classes\EditorScripts Add new below method. void SajuComment(Editor e) {           e.insertLines('//New code added by Saju K'+ ' on ' + 'Begin:' + ' ' + date2str(today                   (),123,2,1,3,1,4 ) +  ''   +' at ' + time2str(timeNow(), 1, 1) + '\n'); } Go to customizing object methods -> Right Click -> Scripts -> Add and enjoy.

1.Go to field properties. 2.General > Value > Click on expression(fx ) > =Format(Fields!TransDate.Value, "dd/MM/yyyy" )