We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Starting in 2019, the Reporting control is no longer included in Essential Studio. If you're experiencing issues with the Syncfusion Reporting Platform, Report Viewer, Report Designer, or Report Writer, we recommend migrating to Bold Reports, our dedicated reporting platform.

Bold Reports offers a comprehensive suite of tools and features for all your reporting needs, and we will help you make a smooth transition from the discontinued control. Our support team at https://support.boldreports.com/ is here to assist you with any questions or difficulties you may encounter during the migration process.

We thank you for choosing Syncfusion and appreciate your understanding.

Excessive memory need with thousands of objects

Hello everyone,I'm searching for a practical solution for a problem with the ReportViewer. I'm working on an WPF application that get's sensor data from an external device. Therefore I have a model Data(which holds metadata for example the DateTime of Recording and so on). This object has a set of the sensor data (Measurements). In on day there are coming around 3000 till 5000+ records to the database. The customer now wants a Report with charting. I have created a View on the database where the two tables (Data, Measurments) are joined togehter (currently around 600k entries).He is also able to build report templates on his own (with the ReportDesigner). My problem occures when I want to display the chart. This will fill up all the available memory, takes a long time and chrashes the application. Despite the fact, that displaying 600k (or more data doesn't make any sense) how can I deal with it?I could create Views for the last day, week, month and create some template reports for it, but even for one week displaying the chart will not work in any good way.Can someone give me a good idea how to handle that?Kind regards

1 Reply

VS Vinoth Srinivasan Syncfusion Team July 3, 2017 05:27 PM UTC

Hi Georg, 
Thanks for your interest in Syncfusion Components. 
We have validated the chart behavior with 600k data in our report designer, it throws out of memory exception when chart has more number of categories. Since, we need to hold the computed point values in series till rendering the chart and that consumes more memory and throwing the exception. As an example, if we are having 600k records and that have 20000 cities then we need to hold the 2000 category point values with X and Y. In this case, we must have a memory to hold the data of report (600k) and chart point data (2000 category). If we have the case to summarize the more data with report then we suggest you to use the report to show the chart with drill through options.  
As an example to show sales of the country, 
  1. Main Report (Country)
  2. Sub Report 1 – Show the states wise data based on selected country in Main Report.
  3. Sub Report 2 – Show the city wise data based on selected state in Sub Report 1.
Please let us know if you have any other questions. 
Vinoth S. 

Live Chat Icon For mobile
Up arrow icon