I am looking for a report of
requirements (marked as use cases),
TC status for each requirement i.e. passed, failed, no-run
Outstanding defects broken by severity for each requirement

Since the requirements have sub requirements below them and TC are marked against them, I am unable to get this at a requirements level.

Any help please?