One of my favorite reports in Microsoft TFS is the Backlog Overview Report (Scrum) or User Story Overview Report (Agile). So after installing and playing with TFS 2013 Preview, I went to see what the report looks like.

What I found wasn’t pretty. Although I could verify that there was data in the warehouse, the report stubbornly refused to show any data.

Backlog Overview Report Settings

Backlog Overview Report

I thought that something was broken with my warehouse, so I dug into the rdl file and into the warehouse database. I could see data, but one of the queries wasn’t returning any data. It turns out the query is looking for the “root” level of “deliverables”. This defaults to the set (PBI, User Story, Requirement) which would work perfectly in the out-of-the-box 2012 templates. But the 2013 templates now root “higher up” in Features. So you have to add Feature to the list. Here’s how to do it:

How To Get Backlog Overview Report Working in TFS 2013

1. Browse to the reports folder root (usually this is http://server/reports) where server is the name of your TFS box. Now navigate through TfsReports to the collection and team project folder where your “Backlog Overview” report is:

Backlog Overview Report SQL Server Reporting Services

Backlog Overview Report SQL Server Reporting Services

2. Hover your mouse over the “Backlog Overview” report and click the arrow to expand the menu. Select “Manage”.

Backlog Overview Report Manage

Backlog Overview Report Manage

3. Click on the Parameters tab on the left and find the parameter called “DeliverableCategory”. Add “Feature” to the list. Don’t forget to scroll down and press the “Apply” button!

Backlog Overview Report Parameters

Backlog Overview Report Parameters

Voila! You now have data when you browse to the report. The PBIs are grouped under their respective Features, which is a nice bonus.

Backlog Overview Report

Backlog Overview Report

Happy reporting!

Ready to Get Started with Your Backlog Overview Report?

If you’re ready to get started with a Backlog Overview Report for your organization but not sure where to start, Imaginet is here to help. Our Imaginet certified TFS and ALM experts have been working with the Microsoft TFS and ALM tools since they originated in 2005 and can help you get started with any of your TFS or ALM initiatives. To find out more, schedule your free consultation call with Imaginet today.

 

Request Your Free Consultation

=====

Imaginet is your trusted technology partner who turns your business innovation ideas into reality. 20+ years | 1200+ satisfied customers | 2500+ successful engagements. Primary services include Web Application Development, Mobile App Development, and SharePoint consulting services, with additional specialties in Power BI & Business Intelligence, Office 365, Azure, Visual Studio, TFS, & VSTS, Skype for Business, and more. Located in the United States (Dallas, TX) and Canada (Winnipeg, MB) with services offered worldwide. Contact us today at info@imaginet.com or 1-800-989-6022.

Imaginet

About Imaginet

Imaginet is your trusted technology partner who turns your business innovation ideas into reality. 20+ years | 1200+ satisfied customers | 2500+ successful engagements. Located in the United States and Canada. Services offered worldwide. Contact us today at info@imaginet.com or 1-800-989-6022.

Let‘s Talk.
  • Let's Talk

  • This field is for validation purposes and should be left unchanged.