I use QC 11
I have a common TestCase "X" which is called in many Test cases.
I want to generate a report to find all test cases which uses the common Testcase "X".
Any filter criteria to enable Tree view instead of above shall suffice as well
This query will get you what you want. Substitute in the name of the called test case for "X" in the Where clause. Make sure you keep the % on either side of the X. I run this query in the Dashboard in an Excel report.
JOIN TEST ON TEST.TS_TEST_ID = DESSTEPS.DS_TEST_ID
JOIN ALL_LISTS ON ALL_LISTS.AL_ITEM_ID = TEST.TS_SUBJECT
WHERE DESSTEPS.DS_DESCRIPTION LIKE '%X%'