Advance ranges example in axapta    SysQuery query;    SysQueryRun queryRun;    QueryBuildDataSource custInvoiceJourDS, custInvoiceTransDS;    ;    query = new Query();    custInvoiceJourDS = query.addDataSource(tablenum(CustInvoiceJour));    custInvoiceJourDS.addRange(fieldnum(CustInvoiceJour, InvoiceAccount));    custInvoiceJourDS.addRange(fieldnum(CustInvoiceJour, CurrencyCode));    custInvoiceTransDS = custInvoiceJourDS.addDataSource(tablenum(CustInvoiceTrans));    custInvoiceTransDS.addRange(fieldnum(CustInvoiceTrans, ItemId));    custInvoiceTransDS.relations(true);    queryRun = new SysQueryRun(query);    queryRun.prompt();     
Microsoft Dynamics Ax,AIF,Axapta, Enterprise portal,,Microsoft , United State,U.S., SharePoint , BI Tools, Performance Tuning, SSRS,Business Logic,Ax ERP Errors and solution,Dynamics 365 Errors Solution,Business software .