I am struggling with reports. I need to have one report that shows all tasks and request that have been assigned to a team so that the manager of the team can distribute the work. I have been trying to use the Assignment report but I can't figure out the columns so that I can see the request.
Questions:
1. Is there a way to automatically filter by a team so that the manager of the team sees only their team
note: I can hard code a filter by team but want it to be automatic
2. Is there a way to combine the name columns from both tasks and requests into one column
note: if not, I can just create a report for tasks and another for requests
3. Is there a diagram that explains the fields that are selectable on the for the reports?
note: I can't figure out which column to display that will show the assigned to (for both the request and the task) so that the manager can quickly change the assignment from the team to an individual.
Thank you for the help