The “Active bugs by Assignment” and “Resolved Bugs by Assignment” chart is not visible in the Bug Status report

by Ewald Hofman 16. July 2010 12:54

I have a TFS 2010 demo box on Windows Server 2008 R2 and SQL Server 2008.

While I was busy in a team project based on the default Agile or CMMI process template, I saw in the Bug Status report something strange. Although I had bugs assigned (of course it was a demo environment, because I never deliver bugs in real life :) ), the chart that should have been shown was not drawn.


So I went into the data warehouse to confirm that the data was correct and I even added a column to the tablix as a double check


And it confirmed what I already thought: the data is correct. So why is the report not showing?

First I updated my SQL Server to the latest version (SQL Server 2008 R2), but that did not make any difference.

Another few hours of trying and modifying did not solve it. I couldn’t get the hang on it. Until I had help from John Socha-Leialohawho was able to solve the issue. What he did is the following:

  1. Download the report from the Reporting site
  2. Open the report in BIDS(the screen shots in this example are from BIDS for SQL Server 2008 R2, so might be slightly different if you use another version)
  3. Select the chart by clicking on it
  4. Right click on the chart to open the context menu

  5. Choose “Change Chart Type” from the context menu
  6. You will see that the stacked bar is chosen

  7. Change the chart type to the Bar chart type

  8. And press OK
  9. Now change the chart type back to “Stacked bar”
  10. Follow the same steps for the Resolved Bugs chart.
  11. And upload the report to the reporting site again (be aware the when you look at the report on the Report site, that it is using a cached report. Just use other parameter values to use the new layout)

And here is the new report that shows the correct result.



Reporting | VSTS 2010


4/27/2011 11:30:32 AM #


Hi Ewald,

I am having some different problem here. My Bug Status report has is not showing anything.
it is giving me following message "There are no results matching the parameters. Try choosing more general parameter values."
Even my parameters are correct. Data is present in Warehouse because because if i run the iteration report it shows that i have 12 bugs. i tired you fix but it did not worked for me do you have any idea for this?

Chanvir Gill  

Chanvir Canada |

Comments are closed

Powered by BlogEngine.NET
Theme by Mads Kristensen


Widget Statistics not found.

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

Recent comments

Comment RSS