Report containing many subreports running slow

kdixon1

I currently have 1 report that contains 10 subreports and it takes over 5 minutes to build out the report. I have ran SQL profiler against the generation and the queries run in less than a minute. Can you give me some pointer to look for in this report that would speed things up?

nicocizik

Hi Kristi,

Which version of ReportBuilder and Delphi are you using? What database and connectivity are you using to connect the report? Are you using DADE or creating your queries in Delphi?

kdixon1

ReportBuilder version 17.01
Delphi Seattle
Our queries are all in the data view tab