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]

You are welcome

[Andrew_TND]

Hi, this is pretty straight forward you create a report based on [sc_task] table and use the grouping by assignment group.

[Charlotte King]

Thank you for your response, but this would give me the department for those fixing the issues, not the department for those logging the issues. I have managed to find this as suggested above by grouping by: Request>Requested for>Department.