Fog light - Enterprise Level Reports Of Expensive Stores Procedures

Hello All

Our management wants the  Enterprise level weekly report of  'Top 10 Expensive SQL Batches/Quries/SP's' .  I dabbled with Fog light's  'Database Expansion Pack' and was able to create it at an instance level .There is no option to combine all  and produce an executive report in a single window.

Did anyone have luck doing something on these lines ? Is is even possible to achieve something like this within Fog Light ? One of the options suggested by my management was to utilize  tables in 'spimsql-XXXXX'  database that Fog Light creates for its reporting and try to Reverse Engineer the process.  Is it a viable option ?

Quite frankly, I am lost of ideas at this time. So , any assistance from anyone around here is highly appreciated

Thanks

-Suresh