Report of all RITMs and their associated tasks

[bartonj32]

Hello,

I am looking to create a report or dashboard of all the opened RITM against our assignment group with their associated tasks. Everything I few posts I have read indicate this cannot be done and I can create the opposite report (tasks and associated RITMS). I find this hard to be true? 

We have RITMs that require multiple tasks to be completed for the RITM to be completed as such we would like to start with the RITMs that our customers have opened and then look at the associated tasks to get the current detailed status. I would love an interactive report somehow. Is this possible???

Thank you

Jason

[brandenwright]

In this case I would create a pivot table report based off of the sc_task table.  The output would look like this.