Reporting by Sales Reps for their Accounts and the activity in their accounts

Summary:

I am looking for a report that would enable the Sales Manager to drill into a Sales Rep, then see a summary of their accounts, then select on an account and see a summary of the activities, opps, etc. for that account. It would also be nice to see a heat chart at the Sales Rep/then Account level if possible

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):