Skip to main content

How to add multiple range for table in axapta

On init method you can use code to add range following way.

 void init()  
 {  
  super();  
 qbrName = this.query().dataSourceTable(tablenum(InventDimCombination)).addRange( fieldnum(InventDimCombination,Name));  
  qbrName.status(RangeStatus::Hidden);  
 qbrItem = this.query().dataSourceTable(tablenum(InventDimCombination)).addRange( fieldnum(InventDimCombination,ItemId));  
 qbrItem.status(RangeStatus::Hidden);  
 }  

Popular posts from this blog

X++ Code to run SSRS Report with parameter in D365 F&O (Example Sales Invoice )

Below is sample X++ Code to run SSRS Report with parameter in D365 F&O (Example Sales Invoice )      Args                       args = new Args();     CustInvoiceJour            custInvoiceJour;     SalesInvoiceJournalPrint   salesInvoiceJournalPrint;       select firstonly custInvoiceJour where custInvoiceJour.SalesId != '';       // Add record to be printed.     // In order to have the context table we need to set args.record().     args.record(custInvoiceJour);       salesInvoiceController = new SalesInvoiceController();     salesInvoiceController.parmReportName(         PrintMgmtDocType::construct(PrintMgmtDocumentType::SalesOrderInvoice).getDefaultReportFormat());       salesInvoiceContract = salesInvoiceController.parmReportContrac...