Need help in modifying a work item report I've drafted. The intent of the report is to show the individual actual effort and remaining effort for a resource(s) by task. All efforts have been manually updated on the work plan. We are not using timesheets.
Right now I can run my report for a single resource, but I'm getting the combined actual and remaining effort totals for a task for all the resources on that same task and not the actual and remaining values that I can see at the workplan level for just the one resource.
I know we can create subtasks and assign them to just one individual resource as a "sort of workaround", but that presents yet another reporting problem...the subtask effort amounts show up for the lone resource correctly but then I'm faced with a duplication on the report of both the subtask and the main task.
Any reporting tips would be greatly appreciated.
Please sign in to leave a comment.
I would break these down into subtasks and use filters in the report to eliminate the duplicates. For example you can set a filter for # of Direct Sub-items = 0 to only pull the lowest hierarchical level in a project, program, or portfolio.