In my last post in this series I covered the new feature for generating reports in Microsoft Excel based on work item query. Let’s look at custom report authoring options available and a few tools next:
As we saw in the previous posts in this series, we ship a lot of useful reports and dashboards out-of-the-box in TFS 2010. In addition, we do open up several options for building your own reports specific to your organizational needs:
Here’s a look at report authoring tools and how they stack up in terms of the power and complexity. I’ve also outlined some of the options for sharing custom reports built using these tools in the image below.
Let’s pivot the tool choice and look at the options based on the kind of reports you can author using these tools:
We ship Excel reports that are available on the SharePoint Server dashboards built in Excel and we also use BIDS to build a few complex SSRS reports like Stories Overview report that’s available in the Agile 5.0 template.
In my next post I’ll cover a walkthrough for building a custom report in Excel. If you have questions or feedback please leave me a comment or send me an email at sunder.raman at microsoft.com