The following can be used in Excel Report generator.
Replace "myPath" with a string similar to 'AAAAAPAAFAAB%' to get the specific parent folder. You will need to check for your specific source Parent in the All_Lists table so that you have the correct path string as there could be multiple folders with the same name! Step names are sometimes the same as well (within the same script!) and can throw out your actual step order the "order by" is required to use test id and step order to give correct order to the returned items.
SELECT TS_TEST_ID as Test_ID, TS_NAME as Name, AL_DESCRIPTION as Folder, TS_DESCRIPTION as Description, DS_STEP_NAME as Step_Name, DS_DESCRIPTION as Step_Description, DS_EXPECTED as Expected_Result, DS_STEP_ORDER as Step_Order FROM TEST INNER JOIN DESSTEPS ON DS_TEST_ID = TS_TEST_ID INNER JOIN ALL_LISTS ON AL_ITEM_ID = TS_SUBJECT WHERE AL_ITEM_ID in (SELECT ALL_LISTS.AL_ITEM_ID from ALL_LISTS where AL_ABSOLUTE_PATH like 'myPath') ORDER BY TS_TEST_ID, DS_STEP_ORDER