I'm going to move this to our Report Lab forum so it can get more visibility. You may also want to look at the Report Lab for solutions.
If you have or are familiar with APM templates, you can assign them to specific nodes. Therefore, when you access them, each APM application will report relevant statistics of the nodes to which they are assigned.
No such relationship exists with reports since you don't assign them. As far as I know, reports live in a world of their own (very much like alerts). They have no idea of the context in which you're viewing them so what you're asking isn't possible.
Hopefully, I'm wrong and someone has a method to accomplish this.
Would you be willing to share your SQL statement that you utilized in order to achieve this?