Hello friends

i have been requested to create a report for calculating the re-run effort of test execution from the test set.

Could somebody help me to get a query to extract the report. The sample report looks like in the below format

Project ID or Name Test ID Test Case Name Execution Date Execution Status Release Type Release Date
Test5187 209876 TC001_Test 4/1/2016 Failed
Test5187 209876 TC001_Test 4/3/2016 Failed
Test5187 209876 TC001_Test 4/4/2016 Passed

Note : I need a project wise report

Appreciate your help in advance