Skip to main content
Question

How to Optimize a report with subreports

  • Nov 2, 2026 8:51 AM UTC
  • 0 replies
  • 5 views
  • Translate All

Forum|alt.badge.img

Hi Everyone,

I modified the Transactions for Account (GL633500) report to display additional information by introducing two subreports. The report is displaying the required data correctly; however, I am encountering performance issues.

The report runs significantly slower than before, and when generating reports for periods with large volumes of data, the process often fails to complete and returns a session timeout error.

I have attached the following reports for reference:

  • GL633500 (main modified report)
  • LCCIPLRef (subreport)
  • POOrdNbr (subreport)

Any suggestions or best practices for improving execution time and reducing the likelihood of timeout errors would be greatly appreciated.