Reports dramatically gets slow using sub-reports

Stimulsoft Reports.JS discussion
Post Reply
rgonzalez26
Posts: 7
Joined: Fri Jun 24, 2022 9:04 pm
Location: México

Reports dramatically gets slow using sub-reports

Post 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.
Attachments
ReportWithoutSubReporte.mrt
(2.87 MiB) Downloaded 65 times
ReportWithSubReporte.mrt
(2.84 MiB) Downloaded 62 times
Lech Kulikowski
Posts: 6271
Joined: Tue Mar 20, 2018 5:34 am

Re: Reports dramatically gets slow using sub-reports

Post by Lech Kulikowski »

Hello,

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

Thank you.
#11915
Lech Kulikowski
Posts: 6271
Joined: Tue Mar 20, 2018 5:34 am

Re: Reports dramatically gets slow using sub-reports

Post 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.
Post Reply