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.
Reports dramatically gets slow using sub-reports
-
- Posts: 7
- Joined: Fri Jun 24, 2022 9:04 pm
- Location: México
Reports dramatically gets slow using sub-reports
- Attachments
-
- ReportWithoutSubReporte.mrt
- (2.87 MiB) Downloaded 65 times
-
- ReportWithSubReporte.mrt
- (2.84 MiB) Downloaded 62 times
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Reports dramatically gets slow using sub-reports
Hello,
We need some additional time to investigate the issue, we will let you know about the result.
Thank you.
#11915
We need some additional time to investigate the issue, we will let you know about the result.
Thank you.
#11915
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Reports dramatically gets slow using sub-reports
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.
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.