Hello,
I think the easiest way to do this would be to create an excel report using the following query.
SELECT TEST.TS_TEST_ID as ''Test ID'', /*Test.Test ID*/
TEST.TS_NAME as ''Test Name'', /*Test.Test Name*/
TEST.TS_SUBJECT as ''Subject'',
TEST.TS_DESCRIPTION as ''Test Desc.'', /*Test.Description*/
TEST.TS_DEV_COMMENTS as ''Comments'',
TEST.TS_TYPE as ''Test Type'', /*Test.Type*/
COMPONENT_STEP.CS_STEP_NAME as ''Step Name'',
COMPONENT_STEP.CS_DESCRIPTION as ''Step Description'',
COMPONENT_STEP.CS_EXPECTED as ''Expected Results''
FROM ALL_LISTS
Left Join TEST on ALL_LISTS.AL_ITEM_ID=TEST.TS_SUBJECT
Left join BPTEST_TO_COMPONENTS on TEST.TS_TEST_ID=BPTEST_TO_COMPONENTS.BC_PARENT_ID
Left join COMPONENT_STEP on BPTEST_TO_COMPONENTS.BC_CO_ID=COMPONENT_STEP.CS_COMPONENT_ID
WHERE
BC_PARENT_ID = TS_TEST_ID
AND AL_ITEM_ID = TS_SUBJECT
AND TS_SUBJECT = ALL_LISTS.AL_ITEM_ID
ORDER BY TS_TEST_ID