Reporting in Team Foundation Server 2010: Part 6: Rich SQL Reporting Services Reports

I started this series with a set of topics and broke the first one down into sub topics to cover the out-of-the-box experience in detail. With my last post, I covered the dashboards portion of the experience. Let’s look at the new SQL Reporting Services (SSRS/RS) reports written in Report Definition Language (RDL). Walkthroughs for…


Reporting in Team Foundation Server 2010: Part 5: SharePoint Foundation Dashboard

In my last post, I covered the topic on creating a team dashboard. Let’s look at the dashboard experience on Windows SharePoint Services / SharePoint Foundation: SharePoint Dashboards SharePoint Server dashboard Out-of-the-box experience Customizing the dashboard Creating a team dashboard Windows SharePoint Services/SharePoint Foundation dashboard Read the rest of the post: http://blogs.msdn.com/sunder/archive/2010/02/18/reporting-in-team-foundation-server-2010-part-5-sharepoint-foundation-dashboard.aspx Follow the series:…


Reporting in Team Foundation Server 2010 – Part 4: SharePoint Dashboards: Creating a team dashboard

In my last post, I covered customizing the SharePoint Server dashboard. The next topic is creating a team dashboard: SharePoint Dashboards SharePoint Server dashboard Out-of-the-box experience Customizing the dashboard Creating a team dashboard Windows SharePoint Services/SharePoint Foundation dashboard Read the rest of the post: http://blogs.msdn.com/sunder/archive/2010/02/02/reporting-in-team-foundation-server-2010-part-4-sharepoint-dashboards-creating-a-team-dashboard.aspx Follow the series: http://blogs.msdn.com/sunder/default.aspx Sunder Raman Program Manager, Team Foundation…


Reporting in Team Foundation Server 2010 – Part 3: SharePoint Dashboards: SharePoint Server dashboard customization

In my last post, I covered the out-of-the-box experience with SharePoint Server dashboard. Let’s look at the next item on the list, customizing the dashboard: SharePoint Dashboards SharePoint Server dashboard Out-of-the-box experience Customizing the dashboard Creating a team dashboard Windows SharePoint Services/SharePoint Foundation dashboard Read the rest of the post: http://blogs.msdn.com/sunder/archive/2010/01/07/reporting-in-team-foundation-server-2010-part-3-sharepoint-dashboards-sharepoint-server-dashboard-customization.aspx Follow the series: http://blogs.msdn.com/sunder/default.aspx…


Reporting in Team Foundation Server 2010 – Part 2: SharePoint Dashboards: SharePoint Server dashboard

In my last post, I outlined the out-of-the-box reporting options available in 2010: SharePoint Dashboards Rich SQL Reporting Services (SSRS) Reports Excel Reports from Work Item Queries Let’s walkthrough the dashboard experience when you integrate TFS with SharePoint. I’ll break this topic down a bit further to cover in detail: SharePoint Dashboards SharePoint Server dashboard…


Reporting in Team Foundation Server 2010 – Part 1: Introduction

This is the first chapter in the series on Reporting in Team Foundation Server (TFS) 2010. In this series, I’ll cover the following topics: Walkthroughs for out-of-the-box experience including customizations Custom report authoring tools and walkthroughs An overview of the reporting architecture Read the rest of the post: http://blogs.msdn.com/sunder/archive/2009/11/24/reporting-in-team-foundation-server-2010-part-1-introduction.aspx Sunder Raman Program Manager, Team Foundation…


Team Foundation Server 2010 – Relational Warehouse and Cube Schema Changes

Team Foundation Server 2010 is a BIG release for us by all counts. We have made conceptual changes; Brian introduced some of the key concepts in TFS 2010 that includes the concept of Team Project Collections (TPCs). These changes required a lot of infrastructure support that we built from the ground up and changes to…

5

Previous State and State Change Count

Today I am going to look at two interesting fields in the Warehouse related to Work Items – Previous State, and State Change Count. The Previous State field stores the state a Work Item was in before it entered its current state.  This field is in the [Work Item] table in the relational/dimensional Warehouse and…

2

TFS Warehouse Work Item Tracking Compensating Records

Compensating Records What are compensating records? First a little background. Whenever a work item is updated a new revision is created. These revisions are moved over to the Warehouse and stored in the various Work Item Dimension and Fact tables. Each revision will be in the Warehouse – however each date will not have a…

2

How Microsoft/DevDiv uses TFS – Chapter 6 (Addendum)

In my previous post, some people asked how we went about creating the report I talked about. I asked the fellow who created this report internally. Here was his response, which I’m passing on to you. (Thanks Doug!) NOTE: I’ve also attached the .RDL file he forwarded along. being quote> Here is the query which…