Query For Excel Report Generation.
I want to generate an Excel File Report with names of all Tests under a Test Set Folder ,with run status and linked defects(if any defects are there).
Re: Query For Excel Report Generation.
You will have to run two reports, one for Test Sets in a particular path, second for the defects.
In Excel you can use a pivot to identify the number of TCs blocked per each defect or to highlight the defect # for each failed/blocked TC.