Creating a Project Velocity Crystal Report using Microsoft Project Server
page 4 of 5
by Eric Landes
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 24202/ 55

Creating the Report

The report for Project Velocity contains a graph and a few details of what is being counted.  The grouping for the report is set by the "actual finish date" field.  This grouping is used for the detail band and the graph.

In the data section of the chart, one of the series for the chart is set for a count of the actual finish date.  The other series are sums of the virtual fields (QOS, Task and Issue).    

The QOS, Task and Issues series are sums since we created the virtual fields to be a 0 of 1, depending on the Task Type of the record.  The line graph then displays a line for each task type that we have a sum for.  This should show you the Velocity for each task type, as well as a total velocity count.

Below the graph we have created a detail banded report that is grouped by actual finish date.  This shows the project manager and other members of the team if the project is gaining or losing speed.  If it looks like the project is losing steam and it should not be, then the PM should investigate.  Investigation can be done utilizing other reports or checking the Looking for blockades to development.  For a sample view see Figure 1 below.

This is the basis of the report.  This can be changed to track things such as Story Points, assuming you make that the task type custom field.

Figure 1 

View Entire Article

User Comments

No comments posted yet.

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2021  |  Page Processed at 2021-11-29 1:03:30 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search