Diving into the Visual Studio Scrum 2.0 Reports

Diving into the Visual Studio Scrum 2.0 Reports

March 13, 2012 | Scrum, TFS 2012

Being the geek I am, I wanted to take a detailed look at the reports in the new Scrum template. Rather than wait for guidance to be posted, or call up my friends at Microsoft (again), I thought I would do my own experimenting.

  1. I downloaded the Visual Studio Scrum 2.0 – Preview 3 process template from the Team Foundation Server 11 Beta into C:Microsoft Visual Studio Scrum 2.0.
  2. I launched SQL Server Business Intelligence Development Studio (BIDS) otherwise known as Visual Studio 2008. (I can’t wait for this to be unified into one IDE someday).
  3. I created a new Report Server Project named ScrumReports.

image

  1. From Windows Explorer, I dragged the eight .rdl reports …

image

… into my Reports folder in Solution Explorer. This makes a copy of the .rdl files under my project.

image

  1. I then created two shared data sources with the exact names that the reports will expect.
    • TfsOlapReportDS: a Microsoft SQL Server Analysis Services connection (Data Source=vstfs;Initial Catalog=Tfs_Analysis)
    • TfsReportDS: a Microsoft SQL Server connection (Data Source=vstfs;Initial Catalog=Tfs_Warehouse)

image

  1. Now I can open any of the reports in the designer and study the layout, built-in fields, parameters, and datasets. I can also preview the reports.

image

  1. I then drilled-down into the various datasets to learn their purpose and how they fit with the report.

image

For larger datasets with larger queries, I copied/pasted the code into this cool online SQL formatter to improve readability:

image