You can order by clause to get record in ascending or descending following way.
CustTable custTable;
//For ascending order
select custTable order by Name asc;
//For descending order
select custTable order by Name asc;
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...