How to create reports based on TFS work items?

Question

A few years ago I saw functionality that allows you to create graphics using TFS, which shows the number of problems on priority for a project (this is related to this. But I can’t find how to do it now.

Please inform:

Question 1 . How to configure TFS for reporting?

Question 2 . How to create reports?

PS I found one article: http://msdn.microsoft.com/en-us/library/ff647430.aspx it looks like you need to write your own application to generate reports ... is this correct?

Question 3 . Is there a turnkey solution for creating reports?

Thanks.

Answer 1

You must have SQL Server Reporting Services (SSRS) installed, then you need to configure the TFS installation to use SSRS. If you didn’t do this when you installed TFS, you can always do it after that by raising the TFS admin console and going through the report configuration. http://msdn.microsoft.com/en-us/library/ee712737.aspx

For all new reports, Team Projects will be created as part of the project creation, if you want to create reports for existing projects, you need to follow these steps: http://blogs.msdn.com/b/greggboer/archive/2010/02/24/ creating-sharepoint-portals-reports-and-upgrading-reports-for-an-existing-team-project.aspx

Answer 2

Another nice solution is to query the cube using Excel. You can right-click on a work item request and select "Open Report in Excel." This creates a beginning from which you can start the setup further. See http://msdn.microsoft.com/en-us/library/dd433251.aspx for more details.

Answer 3

Please note that even if you have Reporting Services installed and configured when installing and configuring SQL, if you have TFS installed in the client operating system, you will not be able to access any of the reporting functions (since the option will never be displayed in the TFS admin console)