Table1valueSumName;
Table2 Table2;
insert_recordset valueSumName (Name, ValueSum)
select Name, sum(Value)
from Table2
group by Name;
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...