Assignments by Resource by Investment

The Assignments by Resource by Investment report helps you see all of the resource assignments for a specified group of resources for a selected date range. Resources are sorted by resource team, and then by each resource, by parent investment, and then by assignment. The report shows the planned starting and finish dates, plus the planned amount of work, and then shows the actual starting and finish dates, plus the actual amount of work completed. The variance between the planned and actual amounts of work is also shown.

The user configurable parameters in this report are:

Date Range Begin Use this calendar picker to select the starting date for the report.
Date Range End Use this calendar picker to select the ending date for the report.
Show Self Assignment Select this option to show assignments to which resources have assigned themselves.

Fields

Descriptions for the fields that are available in this report can be found in the following table.

Field	Description
Team	The name of the resource team.
Resource	The name of the resource.
Investment	The name of the work item that contains the assignment to which the the resource is assigned.
Assignment	The name of the work item to which the resource is assigned.
Self-Assigned?	Indicates whether a resource has assigned themselves to a work item.
Start (Plan)	The date on which all work for a work item will be started.
Finish (Plan)	The date on which a task is scheduled to finish.
Work (Plan)	The amount of work that is estimated
Start (Actual)	The date by which work on a task (or a task plan) actually started.
Finish (Actual)	The date by which work on a task (or a task plan) actually finished.
Work (Actual)	The amount of work that has been completed, to-date, by all resources who have been assigned to a task (or a task plan).
Work Variance	The amount of work that still needs to be completed.

Screen Shot

Screen shot of the Assignments by Resource by Investment system report.

Add Report

To add a report that uses the Assignments by Resource by Investment report template, open the New Report dialog box from the My Reports tab and then follow the steps below.

To add a report that uses the Assignments by Resource by Investment template

Open the Tools module.
Select the My Reports tab.
Click New Report, select Resource Team, and then click OK.
In the New Report dialog box, type a name for the report.
On the General tab, from the Report Template drop-down, select Assignments by Resource by Investment, enter a description (optional), and indicate whether you want to run the report immediately (after you are finished creating it).
Under Associate Report With, click the ellipses button and then use the Select Resource Team dialog box to identify the groups of resources that will be included in the report data.
On the Schedule tab, select Run this report on a schedule if you want the report to be run on a periodic basis. Once selected, you can define how frequently you want the report to be run, the format in which the report will be presented, and how many previous instances of the report you want to store.
If you have chosen to run the report on a scheduled basis, you can use the Recipients tab to select the users, security groups, and security roles who will receive a notification when this report is run. After you have chosen the recipients, click Add.
If you have chosen to run the report on a scheduled basis, you can use the Template tab to define parameters for the email notification. You can define the title (as it will appear in the subject line). You can add the Timestamp and Report Name attributes into the title or the template (the message body). You can add a URL link into the message body that will allow any recipient to link directly to the report.
When finished, click OK.

View

You can view the Assignments by Resource by Investment report directly after adding it by selecting the Run this report immediately option in the New Report dialog box. (Reports can also be run from the My Reports tab in the Tools module or the Reports tabs in the Projects module.) Set the filter options and click Apply Icon Apply.

The filters that are available for the Assignments by Resource by Investment report.

Filter options:

Filter	Description
Date Range Begin	The date from which the reporting period begins. Use the calendar picker to select this date.
Date Range End	The date from which the reporting period ends. Use the calendar picker to select this date.
Show Self Assignment	Indicates whether work items to which resources have assigned themselves will be shown.