Hello. I have entered the query below that will pull the tests with called test steps from the folder specified in Test Plan. The called test steps will be displayed within the calling test steps in the report, in the same order they are displayed in Test Plan. You will need to create a 'New Excel Report' within the Analysis module, then enter the script below into the 'Configuration' tab. If the 'New Excel Report' option isn't available in the Analysis module, then you will need to add the 'ENABLE_CREATE_LEGACY_EXCEL_REPORT' parameter into the 'Site Configuration' tab within Site Admin, and set the value field to 'Y'. I hope this helps.
SELECT
TS.TS_TEST_ID As 'Test ID',
TS.TS_NAME As 'Test Name',
TS.TS_RESPONSIBLE As 'Tester',
DS.DS_STEP_ORDER As 'Step Number',
DS.DS_STEP_NAME As 'Step Name',
CASE
WHEN DS.DS_LINK_TEST is NULL
THEN DS.DS_DESCRIPTION
ELSE DS_LN.DS_DESCRIPTION
END
'Step Description',
CASE
WHEN DS.DS_LINK_TEST is NULL
THEN DS.DS_EXPECTED
ELSE DS_LN.DS_EXPECTED
END
'Expected Result'
FROM DESSTEPS DS
LEFT JOIN DESSTEPS DS_LN ON DS_LN.DS_TEST_ID = DS.DS_LINK_TEST
JOIN TEST TS ON DS.DS_TEST_ID = TS.TS_TEST_ID
JOIN ALL_LISTS AL ON TS.TS_SUBJECT = AL.AL_ITEM_ID
AND AL.AL_DESCRIPTION = '<>'
ORDER BY TS.TS_TEST_ID, DS.DS_STEP_ORDER, DS.DS_STEP_NAME