Help to Improve Efficiency of Transactions Query?

Content

Hi all,

I recently rebuilt one of our oooooold reports that was originally created by my predecessor in the role. The original would break querying a days worth of data thanks to it's long queries on the transactions table and silly amounts of drill downs. I have attached my version that works using report linking. I can run about 10 - 20 days reliably, depending on the size of the team, but still this is quite impractical. I would like to have it run a month reliably regardless of which team but I have no idea how.

The queries it's running aren't very complicated but it's just the fact that it's processing them on the transactions table that seems to kill it. The reports that this links to are all working fine, and can query at least 2 months worth of data (probably much more but that's how much i initially tested). So the issue is purely with the top level report.