We have a Xtra report with XRPivotGrid which is making memory issues after exceeding certain number of rows or pages to render. The report uses Azure SQL server store procedure as datasource and hosted in an Azure Webapp. It is running inside a Devexpress webdocument viewer within MVC HTML page.
Are you investigating any issues in this area? I can give you specific details if it is not a known issue. We have plan B and C in our mind if Devexpress cannot handle large data with this particular control in the report. Please confirm.
XtraReport with PivotGrid
Answers approved by DevExpress Support
Hello Edward,
Regarding the XRPivotGrid control, there are no known memory leaks in the latest versions of our components. The most recent issue that I found in our knowledge base was fixed back in v19.1.
However, since you are using our Web Document Viewer - I assume that the high memory usage may be related to this component's architecture specifics. I recommend you review the following guide to review our official recommendations on reducing memory usage: Memory Usage in Reporting - Best Practices. Take special note of the Web Reporting Components section in this doc.
If this does not help, try following the steps listed in the Memory Usage Continues to Rise section of this guide to review our recommendations on how to diagnose the issue.
Finally, feel free to share your diagnostic results with us. If you see that there is unreleased memory related to DevExpress components in the memory dumps that you collect, I strongly recommend that you include all information listed in the last section of this help topic, to help us replicate and research this issue on our side: Report Memory Leaks to DevExpress Support.