In a CMMI project I am running the "Related Work Items" report and only certain work items are returned (no rhyme or reason that I see). Hundreds of work items should have returned as how the filters are set.

The report(s) are accessing the data warehouse. Open to try/test anything at this point.

Running: Microsoft Visual Studio 2005 Team Explorer -- Version 8.0.50727.147

If the work items were linked recently then perhaps either the warehouse hasn't processed or the report is cached. When you view the report the time the report was generated and the last time the warehouse was processed is displayed near the top of the report. Do these seem correct?

You can disable caching on a report by:
browse to http://<Report Server>/Reports
Select your project
Select the report
Select Properties Tab then Execute on the Left
Select "Do not cache temporary copies of this report"
Apply

You can kick off processing of the warehouse by:
From AT browse to http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx
Select Run -> Run

When GetWarehouseStatus returns Idle processing is complete

If this doesn't work would you try changing your filters on the report to see if you can get them to appear?

Perhaps looking at the differences between one of the work items that is displayed and one that is not displayed will help.

For a work item that is under the same project, in Visual Studio, check the Links tab to be sure it is linked. Also verify the Iteration matches.

From the report click the work item id (should link to something like http://reportchow:8080/WorkItemTracking/Workitem.aspx?artifactMoniker=1904) and verify everything looks correct there. From the Work Items Report find one that should be displayed and check the work item to verify the information there is correct.

Check the eventvwr on the App Tier (and elsewhere) for errors.

If all this works then perhaps try it for a new work item:
Create 2 new test work items and save them.
Process the warehouse
View the (non-cached) Work Items report to verify they are there.
Go back to VS and link one to the other
Process the warehouse
View the (non-cached) Related Work Items report

Sorry I cannot be of more help.

Ran through your steps and still nothing. I hadn't even thought about the report being cached on the server side. I'm spent on ideas, better take a few days off. ;-)

Nick

You got it... it was a problem with the warehouse not refreshing. Thanks again.