Here's what you will need to do. Go to Administration > System > Edit Reports and create a new report.
Add a new 'Custom Section' to the report.
In the custom section dialog box there is a place to enter in a query. Enter in the following:
select R.REQUIREMENT_ID, R.INDENT_LEVEL, R.IS_DELETED from SpiraTestEntities.R_Requirements as R where R.PROJECT_ID = X and substring (anyelement (select value T.INDENT_LEVEL from SpiraTestEntities.R_Requirements as T where T.REQUIREMENT_ID = Y), 1, length(R.INDENT_LEVEL)) = R.INDENT_LEVEL order by R.INDENT_LEVEL
(where you change the ID of the requirement ID to match the one you are trying to find instead of the value "Y" that you see in this example and you change the placeholder "X" to be the project ID). This will then display the requirement IDs of this requirement's parents.
This will then display something like the following:
| REQUIREMENT_ID | INDENT_LEVEL | IS_DELETED |
|---|
| 1 | AAA | False |
| 2 | AAAAAA | False |
| 3 | AAAAAAAAA | False |
| 4 | AAAAAAAAAAAA | False |