index > Team Foundation Server - Reporting > Is there a way to select the executed test cases from the databas...

Is there a way to select the executed test cases from the databas...


I am generating a test case report for our project manager in VSTS. I can set the filed "workitem type" as "test case" to get all the cases. but i do not find a field i can use to get the executed test cases. Anyone can help me? Thanks!


tommy
hydraking

Hi Tommy,

Let me tell you my understanding of your situation, and please let me know if I'm on track or not.

You have created a work item type called "Test Case" that is part of your team project. You have created work items that are of type "Test Case" (as opposed to "Bug" or "Task"). You have executed a few tests and published the test results to the TFS server.

Have you done any linking between the work items created and the test results? If not, then the system wont know that those particular test results belong to that particular work item. You can create reports on test results using the warehouse, but unless the test result is linked to the work item, the system wont know that they are linked.

Thanks,
Mauli

Mauli Shah - MSFT

Thank you for your reply.

I will introduce my situation in details.

My purpose is to show my PM what kind of report VSTS can generate for test cases.

I did not creat work item called "Test Case". Instead, I imported some test cases from Product Studio into TFS server, but i did not import test results into TFS server. Some of the test cases are executed and some are not. There is a field called "CC Scenario" in Product Studio which stored if the test case is executed or not. But i do not find that field in TFSWarehouse. I think maybe i need to import the test result into TFS and judge by that.




tommy
hydraking

Hi Tommy, can you please explain exactly what is what you did you when you say that you imported test cases for Product Studio into TFS server.

In the RTM version of TFS the common way of getting test results into the system is by publishing a test run into an existing build. Work Items in TFS are not meant to represent test cases but you can created links from Work Items to already published test results to build a relationship between them.

Thanks.

Federico

Federico Kolliker Frers - MSFT

Thank you for your reply.

Product Studio is a tool we used to manage bugs and test cases before. We are considering to use VSTS to manage bugs and test cases now. I found a tool in toolbox to import the test case from Product Studio into TFS database. I did not find a tool to import test result from PS into TFS, so the test result in TFS database is still empty yet.

My question is, can i select the executed test cases from TFS database if the test result DB is empty?

From your reply i think the answer is negtive. I need to publish some test result to TFS and create link from the test cases and the test result.




tommy
hydraking
Hi Tommy, do you work at Microsoft? You are talking about Product Studio and toolbox so it seems you are. If you are please contact me directly to fedek@(nospam)microsoft.com so we can get in touch so I can learn more about how that tool in toolbox works and see how can I help you.
Federico Kolliker Frers - MSFT
reply 6

You can use google to search for other answers

 

More Articles

How do I create a new QA Report in Team System
No report image in Project Portal, but do see one via IDE..
Only Team Sytem cube is visible
Reporting on Plain Text Fields in Work Items
Reports not accessible through project portal by remote user
error whyle tryng to export to excel
Unplanned work report incorrect
Cross Project Reports
How do i edit or delete reports?
Report server problem.
Welcome to Bokebb   New Update   Joins the collection  
 

New Articles

Adding Data Region to existing items
Quality Indicators Report
urgent: Connection Problems
Report Path!
Team System Warehouse Problems
Issues in using reporting services we ar…
Failed to generate reports
Error executing reports in RTM Trial
Problem accessing TFSwarehouse using OLA…
Report Checked Out Items and Changed Items
"Hidden" reports in RTM ..
Passing new parameters to Report(.rdlc)
Can't get access to reports if the data …
schedulingfinishdate error + how to add …
TFSWarehouse shows data but reports come…

Hot Articles

Getting TFS Reports working again after …
Only one CUBE in Team Foundation Server
Date validation
How to accss Symptom and StepsToReproduc…
Another TFS Warehouse problem...
How do I fix the TfsOlapReportDS user pr…
Why there is a fork icon in my report fo…
New Project -- Reports Not Working Immed…
TFS Report Error
After upgrading to latest VSTS reports a…
Related WOrk Items With Code files?
Setting for URL in Reporting services
Report server problem.
Warehouse error question?
How to update 2005 report definitions to…

Recommend Articles

How do I fix the TfsOlapReportDS user pr…
Only Team Sytem cube is visible
How to Updating report from stored proce…
Report Path!
Code churn == Non binary churn?
Creating an OLTP datasource for writing …
how to produce reports using rs with fea…
Simple query to find work items resolved…
No report image in Project Portal, but d…
What is the formal definition of Priorit…
Problem with WI's and reportable="d…
Reporting on inforamtion in work item hi…
Problem accessing TFSwarehouse using OLA…
Print reports without preview
Can I customize the VSTS bug report?