Project Query Report on Associated Requests

Project Query Report on Associated Requests

I am hoping a query can be built to report on the following:

A specific Project name where we can view all the associated request ID, subject lines and request status then this requests' associated tasks, task owner and task status

Project Name:
Request ID      Subject      Status
      Task      Task Owner      Task Status
      Task      Task Owner      Task Status
Request ID      Subject      Status
        Task      Task Owner      Task Status
        Task      Task Owner      Task Status
Request ID      Subject      Status
        Task      Task Owner      Task Status
        Task      Task Owner      Task Status
        Task      Task Owner      Task Status
        Task      Task Owner      Task Status

                  New to ADSelfService Plus?