I would like the user to be able to click a button on the web page that will run a SQL query (canned report) and export the result data to an Excel spreadsheet. The data does not need to display on ...

In the second part of this two-part series, Mickey Gousset shows how TFS 2010 lets users create Excel reports, including pivot tables and charts, from a work item query. The report can then be ...

If you’re looking for a straightforward method to automate the generation of Excel reports, such as those for end-of-month financial results, there is a simple solution that can save you time and ...