SSRS Reports using the QueryInsertRecordSet in D 365 FO
Logic for Report Using QueryInsertRecordSet: I used QueryInsertRecordSet that will insert the data in one trip and it is faster than insert recordset and also we are not using the contract class and it works fine. The Key point here is that we have to make the Report Data Set Property(Dynamics Filters to True) to make the logic working. This is required to access the DP class query in the controller class. Printing the report for selected record in the SalesQuotationJournal. [ SRSReportQueryAttribute(queryStr(SalesQuotationQuery)) ] class gbSalesQuotationDP extends SrsReportDataProviderPreProcessTempDB { SalesQuotationTmpTable salesQuotationTmpTable; CustQuotationJour custQuotationJour; CustQuotationTrans custQuotationTrans; /// <summary> /// /// </summary> private void addInsertFieldMapping(QueryBuildFieldList _fieldList, Map _fieldMapping, int _sourceTableUniqueId, FieldId _sourceFieldId, FieldName _sourc