Problem when loading a report

RobertHerceg · Post by **RobertHerceg** » Mon May 14, 2012 10:40 am

Version: Stimulsoft.Wpf 2012.1 Trial.

I have a report with one DataBand that is connected to a collection of .NET objects.
The report is displaying three columns.

If the collection is small (up to thousand rows) then the report is loaded relatively fast (it takes up to several seconds).
However, loading a collection of ten thousand objects is really slow.
It can take several minutes to load, the CPU is at 100%, and the application looks dead.
I have also tried the latest prerelease version with the same result.

Is there any way how to improve loading of large data?

Post by **HighAley** » Tue May 15, 2012 9:32 am

Hello.

RobertHerceg wrote:Version: Stimulsoft.Wpf 2012.1 Trial.

I have a report with one DataBand that is connected to a collection of .NET objects.
The report is displaying three columns.

If the collection is small (up to thousand rows) then the report is loaded relatively fast (it takes up to several seconds).
However, loading a collection of ten thousand objects is really slow.
It can take several minutes to load, the CPU is at 100%, and the application looks dead.
I have also tried the latest prerelease version with the same result.

Is there any way how to improve loading of large data?

Please, send us a report template with data for a big report or a sample project to reproduce the issue with a large data.
And we'll try to help you.

Thank you.

RobertHerceg · Post by **RobertHerceg** » Wed May 16, 2012 5:07 am

I have just attached the test project in VS2010 which demonstrates the problem.
To get it running it will be necessary to update references to Stimusloft binaries (I had to exclude them from the zip as it was too large).

Some notes to the project:
Reports\TestReport.mrt ... this is the stimulsoft report which should be displayed
ViewModel\ReportViewModel .. the view model contains the data for the report
Converters\BusinessReport2StiReportConverter .. converts the ReportViewModel to StiReport before it is loaded

Post by **HighAley** » Thu May 17, 2012 10:09 am

Hello.

Sorry, we need time to prepare an answer for you.

Thank you.

Post by **HighAley** » Thu May 24, 2012 8:51 am

Hello.

We couldn't find out the reason of the freezing of the application.
Maybe the cause is your Business Objects or Converter.

Thank you.

RobertHerceg · Post by **RobertHerceg** » Fri May 25, 2012 4:19 am

Well, the performance profiler in VS has said something else.
It looks like the app is meditating and reaching Nirvana while in the StiReport.Render() method.
See the attached 'call tree' snapshots. Is there any way how to configure DataVirtualization? Something like - load first 10 pages, then another 10 pages and so on ..

RobertHerceg · Post by **RobertHerceg** » Tue May 29, 2012 4:06 am

In case that you are not able to reproduce the problem. Could you please post a sample code (project) with large amount of data working? Thanks.

Post by **HighAley** » Tue May 29, 2012 10:36 am

Hello.

We've found the reason of your problem.
Tomorrow we'll send you rebuilt report.
Also we'll make code optimization that will be available in our next prerelease build.

Thank you.

Post by **Ivan** » Wed May 30, 2012 9:42 am

Hello,

Please check the report in attachment.

Thank you.

RobertHerceg · Post by **RobertHerceg** » Wed May 30, 2012 3:37 pm

Hello,

Excellent. This is much better. It still takes some time to display the ten thousand records, but it is much better now.
I will compare the modified report with the original one to find out what has to be changed. I need to modify also other reports that can be displayed on many pages.

Thank you