Inadequate memory consumption when printing 2-tables dataset

[WalterJKR]

Hi,

we have simple dataset with two tables joined with relation through long (id).
The report is printed correctly if we have a few rows in each table. But when we try to print the report with 7000 rows in master-table and around 7000 rows in the child-table, to printing process in really slow (around 15 seconds per page, depending on computer) and the process ends with "An unhandled exception of type 'System.OutOfMemoryException' occurred in Stimulsoft.Report.dll". During the printing process, the memory of the aplication slowly raises and the exception occurs when it reaches 1.2GB (or so).

I tried to set CacheAllData property to TRUE but it didn't help. Using version 2014.1 and 2013.x.
Can you find out where is the problem and help us?

See the attached project for more information, it contains report definition and data, just build it and run.

Thank you for your help!

[HighAley]

Hello.

You forget to set the Relation property of the detailed band. So you get 7000 detail bands on each of 7000 master band.
If you set the Relation then you can remove the Conditions of the components on it.

Thank you.

[WalterJKR]

Yup, that was the solution. Our bad...
BTW, the engine rendered 28.000 databands per second. Awesome!!!

[HighAley]

Hello.

We are always glad to help you.
Let us know if you need any additional help.

Thank you.