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
VSVinoth Srinivasan Syncfusion Team July 3, 2017 05:27 PM UTC
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,
Main Report (Country)
Sub Report 1 – Show the states wise data based on selected country in Main Report.
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.