This content has been marked as final. Show 3 replies
Can we use any SQL Query ...
What is the field type of the Taskuser field and how are you inputting the value in it?
The report is working as expected. Since you are using the department from the user database, the department of the owner would be displayed and not the department of the task user. Hence, you need to tweak the solution
The solution is as follows:
Create another text field TaskUser Department.
When the owner enters the taskuser field, then you need to populate the Task User Department field with department of the task user.
Depending on what is populated in the Task user field you can use a workflow to enter the task user department or the owner needs to manually enter the value.
In the report instead of using the department field, you can use the task user department field and you would achieve your result.