Custom report by release, test case priority, and execution status and statistics tables

Tuesday, September 23, 2014

I Want to create a report that includes the following fields:

Test Set NameTest Set DescriptionTest Case NameTest CasePriorityTest Execution StatusActual Result for First Step Failed
test set AAll the test set custom list as stringTest 1CriticalPassed
test set BTest 2HighFailedFailed bacause of ...
test set CTest 3MediumNot Run
LowBlockedBlocked because of ...
CautionCaution because of ...

Also the following statistics tables:

Status1 - Critical2 - High3 - Medium4 - LowTotal per execution status
Passedtotal passed
Failedtotal failed
Not Runtotal not run
Blockedtotal blocked
Cautiontotal caution
Total per test prioritytotal criticaltotal hightotal mediumtotal lowtotal test

Status1 - Critical2 - High3 - Medium4 - LowTotal % per execution status
Passed %% passed from total critical% passed from total high% passed from total medium% passed from total low% passed from total tests
Failed %% failed from total critical% failed from total high% failed from total medium% failed from total low% failed from total tests
Not Run %% not run from total critical% not run from total high% not run from total medium% not run from total low%not run from total tests
Blocked %% blocked from total critical% blocked from total high% blocked from total medium% blocked from total low% blocked from total tests
Caution %% caution from total critical% caution from total high% caution from total medium% caution from total low% caution from total tests
Total % per priority% total critical from total tests% total high from total tests% total medium from total tests% total low from total tests100%

I much appreciate any help with this issue...

Many thanks,
Taha Massalha
4 Replies
Tuesday, September 23, 2014
re: taha Tuesday, September 23, 2014

Also I want the report per release, and ordered by priority then execution status, then test set name
I stuck with this issue from a couple of days and always I got a different tests number from the built in "test set detailed" report with the tests coverage.

again, much appreciation for you help
Friday, October 10, 2014
re: taha Tuesday, September 23, 2014
Any help, please...
Tuesday, October 14, 2014
re: taha Friday, October 10, 2014
Hi Taha,

Could you please log a help desk ticket about this? Make sure to include as much detail as you can, for example, the version of SpiraTest you are using, what you have tried so far, any relevant screenshots, and so on.

Wednesday, April 15, 2015
re: inflectra.kat Tuesday, October 14, 2014
For those reading the thread, the issue with the numbers was that the built-in report filters out deleted test cases, so we recommended adding a "where is_deleted = false" clause into his queries. That fixed the issue.

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885


  • Started: Tuesday, September 23, 2014
  • Last Reply: Wednesday, April 15, 2015
  • Replies: 4
  • Views: 2614