This blog post will make use of the some of the new web test API's added in VS 2008 SP1.  This post will use the API's to collect additional web test information and then show you how to use excel to generate reports with this data.

http://blogs.msdn.com/slumley/pages/reporting-on-web-tests-using-new-web-test-api-s.aspx