Subreport Performance

Hello Allu2026u2026..

I have a report with 2 subreports. Both subreports contain data from an outside source which is uploaded into a user defined table. When the main report had just 1 subreport, it ran fairly quickly. But when I added the second subreport, it ran for 6 hours or more. Both subreports are constructed basically the same and when run independently, they run quickly. The main report grouping is the same for the 2 subs. I have the 2 subs linked by by the same data field and also have a parameter set up for start & end date which is submitted by the user and driven from the main report. These parameter fields link back to the subreports which have the same start u2013 end fields. I do not know why the run time is so long with the secind subreport added.

All shared variables are working correctly and I am seeing correct expected results, I'm not sure why it takes all day to refresh.

Anyone experience something similar or have any suggestions or comments as to what could be elongating the refresh time.

Thanks Dave