Technical Tutorials on MS Dynamics Axapta 2012,D365 FnO

To Delete duplicate records  from salesTable or any other table through ax 2012 by x++ code you can write code in Ax job. Set fieldSet = new set(Types::Integer); DictIndex IndexName = new DictIndex( tablenum(SalesTable), indexnum(SalesTable,SalesIdx)); int i; ; if(IndexName.numberOfFields()) { for(i=1;i<=IndexName.numberOfFields();i++) { fieldSet.add(IndexName.field(i)); } ReleaseUpdateDB::indexAllowDup(IndexName); ReleaseUpdateDB::deleteDuplicatesUsingIds(tablenum(SalesTable),0, fieldSet); ReleaseUpdateDB::indexAllowNoDup(IndexName); } info("Duplicate records deleted successfully");

For Calling a SSRS Report from x++ in Ax 2012 you can try following code hints. You can use SrsReportRunController  class to call SSRS Report. SrsReportRunController controller; controller = new SrsReportRunController(); controller.parmReportName(ssrsReportStr(TestReport, Detail)); controller.startOperation();

To set Alert in Ax 2012 its easy. You can visit following link to get step by step details. http://daxing2012.wordpress.com/2012/11/19/alerts-in-ax2012/  

I want to share a link to get details about Data Export Import using Excel Add-in in Dynamics AX 2012 . http://ax2012exceldataimport.blogspot.in/

To Display query which are currently exceuting from form datasource in Axapta. You just need to user toString method with Querybuilddatasource clase object, Query q; QueryBuildDataSource qbds; ; q = this.query(); qbds = q.dataSourceName("CustTable"); strfmt("%1", qbds.toString());   

This UI Builder class is a class help you to customize your dialog which pop ups when you open a Report. UI Builder Class also  helps you to add run time lookups and other controls like combobox,textbox,checkboxes etc on the dialog form. I want to share import Link for Simple UI Builder Class in SSRS Report in AX 2012 . http://kdynamics.blogspot.in/2013/09/simple-ui-builder-class-in-ssrs-report.html

I want to share a good link to get some Tips  to improve performance in Microsoft Dynamics AX 2012 Reporting Just visit on following MSDN help link. Tips to improve performance in Microsoft Dynamics AX 2012 Reporting