Change the Bug Status report to reflect additional states to the Bug

by Ewald Hofman 16. July 2010 13:42

The bug work item has 3 (Agile: Active, Resolved, Closed) or 4 states (CMMI: Proposed, Active, Resolved, Closed). Those states are used also in the reporting. When you use additional states you will see that the colors are not in the trend that the default states have. Also the order of the states might not be in the correct order. The last requirement I have in this case (because this bug work item has 10+ states) is to aggregate some states into categories to see less states.

This post shows you have you can achieve these requirements.

image

In order to support the new states in the report, you have to change the rdl.

  1. Go to http://msdn.microsoft.com/en-us/library/ff730838.aspx to find out how you can start up a new Visual Studio project to modify the report
  2. Now download the Bug Status (you can find the instructions how to do that in Reflect the rename of a state for the Bug Work Item)
  3. And add the Bug Status report to the project
  4. Open the report by double clicking it. You will see something similar like this

    image
  5. First we are going to solve the coloring
    1. Now right click on the orange / blue area to open the context menu for the data series

      image
    2. Choose for the Series Properties
    3. And go to the Fill section

      image
    4. Now click on the fx button to open the expression for the color

      image
    5. You see the list of states and its colors. The color is specified as (Transparancy, Red, Blue, Green). The transparancy of 80 means (because it is a Hex value) 50%. Play around with colors to get the result you want.
  6. Now we also need to change the sorting of the states
    1. To do that click on the data series again and scroll completely to the right

      image
    2. You see that there is a window shown with the Chart Data.
    3. Click on the triangle in the Series Groups

      image
    4. And choose the “Series Group Properties…”
    5. Go to the Sorting section

      image
    6. Click on the fx button to change the sort by expression

      image
    7. Again you can modify this expression to get the correct sorting. The !1, !2 and !3 are just textual values to ensure that they are alphabetically sorted before Active, Assigned and so on.
  7. The third modification you might want to make is to aggregate a few states. If you want to do that, you should change the value for the Series Groups from System_State to an expression.

Tags:

Reporting | VSTS 2010

Comments

7/20/2010 1:39:56 AM #

Bjorn Anderson

Thank you for the clarification. You helped me a lot.

Bjorn Anderson France |

7/23/2010 7:27:20 AM #

trackback

Reporting Blog Posts and Articles

For those in the business of modifying reports included in the MSF Agile, MSF CMMI, or Microsoft Visual

Aaron Bjork |

3/1/2016 8:23:49 PM #

blogs.msdn.microsoft.com

Pingback from blogs.msdn.microsoft.com

Reporting Blog Posts and Articles | Aaron Bjork

blogs.msdn.microsoft.com |

Comments are closed

Powered by BlogEngine.NET 1.6.1.0
Theme by Mads Kristensen


ClusterMap

Widget Statistics not found.

There is an error in XML document (0, 0).X

Recent comments

Comment RSS