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

[johnfeist]

Hi Barton,

What you need to do is create a report using sc_task as the table.  When you are selecting your data, you will notice that Requested Item is green.  If you click on that you will see another icon above the < and > between the two lists.  Clicking on that will allow you to access the the Item level data.

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster

[bartonj32]

So we cannot get the report I requested from the Req Item? As noted in my response above it is difficult to assess the stage doing this unless I am doing something wrong. I just want to be able to look at users' requests and see the associated stage and then  easily drill down on the tasks if the Req Item is not completed.... but to do this I have to create a report on tasks and pull the Req Item out through the tasks? This just seems backwards, no?

[johnfeist]

Yes, it looks backwards.  The alternative is to build the view that others have suggested where you join sc_req_item and sc_task.  From there, you can build your top level which will show the data about the various items.  You can then add a drill down to your report so that when you click on an item it will show you the various tasks assigned to that item.  That might be cleaner and easier to use.

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster

[manjusha]

Hi,

create database view to combine data of both tables those are sc_task and sc_req_item.

thanks,

Manjusha

[Jaspal Singh]

Hi,

Report something as below should work.