Page 1 of 1

Reports dramatically gets slow using sub-reports

Posted: Wed Jul 12, 2023 11:26 pm
by rgonzalez26
Greetings.

I'm using the stimulsoft designer 2023.2.6 and I have a report that gets really slow to load when I use subreports on it. I attach both mrt files, one with subreports and another without them. Aditional to this both reports works with a long JSON, but only the one with subreports gets extremaly slow at loading (more than 20 minutes).
It's there any recommendation for working with reports that has this kind of conditions?

Thanks in advance.

Re: Reports dramatically gets slow using sub-reports

Posted: Fri Jul 14, 2023 10:29 am
by Lech Kulikowski
Hello,

We need some additional time to investigate the issue, we will let you know about the result.

Thank you.
#11915

Re: Reports dramatically gets slow using sub-reports

Posted: Thu Jul 20, 2023 1:12 pm
by Lech Kulikowski
Hello,

What product are you using exactly?
Your post in the JS thread, but the report is made in WinForms designer.

Also, you have BOTH reports using subreports.
"ReportWithSubReporte.mrt" contains one subreport, and "ReportWithoutSubReporte.mrt" contains 3 subreports.
But both reports are done incorrectly.

"ReportWithSubReporte.mrt"
on the Dataroot band there is a subreport with the DataBand2 band. Both bands have the dataSource "root" assigned to them.
I.e. a band in a band is spun up, and it should result in about 400 thousand pages. If you remove the source from Dataroot, you get about 700 pages.

"ReportWithoutSubReporte.mrt."
SubReport1 and SubReport2 subreports are directly on the page. So the engine spins them not as on the band, but as in a container, one strip per page, about 20 thousand pages.

Most probably, this is not the result you wanted to get in both reports.

Thank you.