Data Virtualization

koraykazgan · Post by **koraykazgan** » Tue Apr 19, 2011 3:38 am

Hi Stimulsoft guys,

I have designed a report, which can have very large data (Report with SQL Data Source). If I try to show it in the viewer control, I get a "Out of memory" exception from the viewer. I was testing that on a machine with 2GB Ram. The report should have 6000 pages.

What I wanted to know is, if you have any solution for large reports. Do you have any ideas.
Can you tell me, how I can get such large reports be rendered without any problems? What are your suggestions?

Thanks for help,
Koray

Post by **Alex K.** » Wed Apr 20, 2011 1:27 am

Hello,

Please try to set ReportCacheMode property of report to On.

Thank you.

JorisWils · Post by **JorisWils** » Thu Apr 21, 2011 9:41 am

I have tried this with a report that took 5.4gigs of ram, but it still went up to 5.3gigs at some point of rendering, so it might not work in every case.

Post by **Andrew** » Mon Apr 25, 2011 9:16 am

Hello,

Which version of our product are you using?
In the latest release we have made many optimizations, please try them.
If it does not help - can you, please send us a sample report with data or a simple test project, which reproduces the issue?

Thank you.

koraykazgan · Post by **koraykazgan** » Fri May 13, 2011 2:08 am

Hi,

I have tried the latest version of Stimulsoft Reports.Wpf. I have a simple report where one row in db in presented in a single line in the report. My database has 1 million entries. So I set ReportCacheMode to On and tried to get the report rendered. It took more than 8 hours. After that I had no more memory (totaly I have 8GB) and my system was not responding anymore.

I tried to look for documentation, what these cache properties in the report exactly do, but couldn't find anything. Is there any documentation about the caching concept in reports? Or can you explain me, what it exactly does? I also found a "Cache all data" checkbox on the report. I neither know what this option is doing.

Is there any possibility to just query the data for the page, which will be rendered, instead of pulling all the data from database at once? So if I have a report with 6000 pages, but the user looks only at the first 3 pages, only the data for the first 3 pages are loaded. Is this possible?

I am not sending you an example, because you can reproduce it even with the simples report with large data. Hope you can help me with my problem.

Regards,
Koray

Post by **Alex K.** » Mon May 16, 2011 7:11 am

Hello Koray,

In this case, if the user needs to display only a part of the data, you can use parameters in the query. Set the ConnectOnStart property for the data source to false and when a user inputs parameters to connect to the data.

Thank you.