Cross Module (cross table) reporting

Looking for the ability to quickly generate reports and queries that span across the database.

Here is an example that I am currently achieving by other means:
The ability to script queries to the mysql database. Capture the results. Run calculations on the returned arrays (via php or javascript). Generate a report on the complete CRM pipe line. Ex: Value of total leads, opportunities (grouped by status), quotes, contracts and invoices.

Perhaps create a dashlet out of this as well??

Anybody got any thoughts? Can you point me in the right direction?

Hi there,

Have you looked at KReporter? It allows you to report on all modules and store values returned from fields and then construct formulae to perform calculations on the stored data from the fields.