Skip Navigation LinksHome Page > Forums > SpiraTest Forums > SpiraTest Issues & Questi... > Custom report by release,...

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

Tuesday, September 23, 2014

reporting

taha

Hi,

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

Test Set Name	Test Set Description	Test Case Name	Test CasePriority	Test Execution Status	Actual Result for First Step Failed
test set A	All the test set custom list as string	Test 1	Critical	Passed
test set B		Test 2	High	Failed	Failed bacause of ...
test set C		Test 3	Medium	Not Run
			Low	Blocked	Blocked because of ...
				Caution	Caution because of ...

Also the following statistics tables:

Status	1 - Critical	2 - High	3 - Medium	4 - Low	Total per execution status
Passed					total passed
Failed					total failed
Not Run					total not run
Blocked					total blocked
Caution					total caution
Total per test priority	total critical	total high	total medium	total low	total test

Status	1 - Critical	2 - High	3 - Medium	4 - Low	Total % 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 tests	100%

I much appreciate any help with this issue...

Many thanks,

Taha Massalha

4 Replies

Tuesday, September 23, 2014

taha

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

Taha

Friday, October 10, 2014

taha

re: taha Tuesday, September 23, 2014

Any help, please...

Tuesday, October 14, 2014

inflectra.kat

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.

Thanks!

Elise

Wednesday, April 15, 2015

inflectra.david

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

Statistics

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

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

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

Edit Thread

Edit Message

Search Results