Background
A customer asked us - I work in a project which has requirements traced directly to test steps and I would like the ability to report on execution progress at the test step level. I'd like to see which test steps are passed/failed, and if they are traced to a requirement.
Custom Report
If you use the following Entity SQL as a custom section:
select RS.REQUIREMENT_ID, RQ.NAME AS REQUIREMENT_NAME, TC.TEST_CASE_ID, TC.NAME AS TEST_CASE_NAME, RS.TEST_STEP_ID, TS.EXECUTION_STATUS_NAME
from SpiraTestEntities.R_RequirementTestSteps as RS
join SpiraTestEntities.R_Requirements as RQ on RS.REQUIREMENT_ID = RQ.REQUIREMENT_ID
join SpiraTestEntities.R_TestSteps as TS on RS.TEST_STEP_ID = TS.TEST_STEP_ID
join SpiraTestEntities.R_TestCases as TC on TC.TEST_CASE_ID = TS.TEST_CASE_ID
where RQ.PROJECT_ID = ${ProjectId}
It will display the following report for you:
| Requirement ID | Requirement Name | Test Case ID | Test Case Name | Test Step ID | Execution Status |
|---|
| | | | | | |