Over due and delayed tasks to be shown on Report based on Task table

[Anubhav Prakash]

Hi All,

I want to create a report where I need to show those tasks assigned to Billing group and group them by assigned to (this part is done) but I need to also show that what all tasks are delayed and overdue and by how many days.

Thanks in advance.

[Slawek_Radziewi]

In order to see such data you should use task_sla table. 

[Anubhav Prakash]

But I need to show also assigned to and the group but task_sla table will not have these columns.

Sorry I am new to reporting. 

Any help would be highly appreciated.

Thanks in advance.

[Adam Stout]

Can't you just dot walk from task_sla to task to get the assignment group?

[Anubhav Prakash]

Thanks a lot for your advice I will try this and update here.