Hi,
I am using Dynamics 365 Finance and Supply chain 10.0.26 Update 50.
I have a requirement to add a new dataset to the Purchase Inquiry report data provider.
I have created an extension of the PurchPurchaseOrderDP class and created a regular table to provide the data.
In my extension I have my method with the SRSReportDataSetAttribute decorator that returns the table, I also have the methods to create the records also using the setTransactionConnection.
In SQL Server, I can see the records being created correctly and with matching createdTransactionId.
I then created a copy of the PurchPurchaseOrder report and added the dataset (issue happens with and without changing the design). Compiled and deployed.
Lastly I extended PrintMgmtReportFormatPopulator so that I can set the report in the Print Management
Question 1
However when I try to print using this design I get an error:
"No report data table with name <dataset table name> exists in report schema for data provider <RDP name>."
According to Microsoft this means:
"Verify that the report is bound to tables that exist and do not bind multiple datasets to a single report data provider class. Instead, define the report to have the multiple tables pointing to the same dataset."
But what does this mean exactly? My report already has 2 datasets coming from the same DP class so why does the new one cause the problem?
I have also tried cloning the entire data provider to make sure its not an extension problem, but I get the error anyway. I've compiled, deployed the reports, restarted SSRS, deleted my usage data, not sure what else to try
Question 2:
The table is a regular table, which is how PurchPurchaseOrderHeader (for instance) is. When and how does the table get cleaned - is there a batch job for example for this?
