List list; Query query;
args = new Args(); list = new List(Types::String);
list.addEnd(fieldstr(ProjTable, ProjId));
list.addEnd(fieldstr(ProjTable, Name));
list.addEnd(fieldstr(ProjTable, Status));
sysDataSetLookup.parmLookupFields(list);
sysDataSetLookup.parmSelectField('ProjId');
// Call query
query = projTimeSheet_ds.getProjectIDQuery();
// Pass the query to SysDataSetLookup so it result is rendered in the lookup page. sysDataSetLookup.parmQuery(query);
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...