How can I create a report on sctasks which groups them by department?

[Charlotte King]

Hi,

I need to produce a report on our current open sc tasks and arrange it by department. 

I can't select department from the options and can't find a way around this. Is this a case that a database view needs to be created? (I don't have admin rights so would need to ask our admin team if this is the case)

Thanks,

Charlotte 

[Ashutosh Munot1]

Hi,

How you determine which department has which task?

Is it linked with User, Assignment group or Assigned To?

Thanks,
Ashutosh

[Charlotte King]

Hi, Assigned to 

[Ashutosh Munot1]

Hi,

Do this:

Thanks,
Ashutosh

[Charlotte King]

Oh sorry I misunderstood, this would give me who the task is assigned to. We are after the department of the 'Requested for' person. 

I can produce this report under the incident table by using 'Caller-department' but don't have these options on the task table.

Thanks,

Charlotte