Currently, SSRS reports on out platform fails to handle a large number of records. When the number comes to millions, the reports will take extremely long time to proceed the reports. And, in many cases, the report will fail.
One example can be mentioned is Inventory settlement adjustment report. More details can be found at: LCS > Issue 979603. The report data provider class loops through all the found records and insert them all into temporary table for the printout. Yet, when the number of loops becomes too big, this will not work.
Hence, I would like to suggest an idea of performance improvements for SSRS reports in general.
Comments
ERP such as Microsoft Dynamics 365 FinOps are used by enterprise customers who have large volumes of transactions. The reports (not limited to Inventory adjustment report) need to be designed to handle this volume. It has been observed that most of the standard reports do not work in volumes. Request you to come out with a solution for this.
Category: Inventory