Crystal Reports Stock Report Descriptions › Resource Assignments Report

Resource Assignments Report

Description

This report shows resources assigned to projects and tasks including actual hours and ETC hours.

Run the report to work with resources.

See the Resource Management User Guide for more information.

Prerequisites

• For projects, the resources require assigning to project tasks from Open Workbench or Microsoft Project to display assigned hours.
• To use the OBS Unit parameter to filter the report, add at least one OBS to the system. In addition, assign an OBS unit to the programs or projects.

Parameters

Group By

Indicates the grouping and presenting of information on the report. Select an option from the drop-down.

Period Type

Indicates if the weekly or monthly period type requires reporting.

Project

Indicates the projects to generate the report.

Resource

Indicates the name of the resources to generate data in the report. Click the Browse icon and select names from the list that appears.

Resource Manager

Identifies the resource managers whose data displays in the report. Click the Browse icon to select names.

Resource OBS

Indicates the OBS unit to filter the report. Click the Browse icon and select the OBS from the list.

Starting Period

Defines the start date of the report. To select a specific day, select the Specific Date option and type a date in the text field in the mm/dd/yyyy format. Or, click the Date Picker to select a day from the calendar that displays. To select a relative date such as Start of Next Month, select the Relative Date option. Then, select the relative date from the drop-down list.

Type of Hours

Indicates the type of hours to generate the report (allocated or assigned). You can select multiple items.

Graph

The report contains a graph that shows the assigned hours for resources on the report compared to the allocated hours for resources.

Report Fields

Actuals (h)

Displays the hours charged to the project for the time period selected.

Database Tables and Columns:

nbi_project_res_task_facts.actual_qty

Assigned (h)

Displays the assigned hours.

Database Tables and Columns:

A calculated field. For more information, see the report SQL statement.

End Date

Displays the end date for the reporting period.

Database Tables and Columns:

prtask.finish

ETC Hours

Displays the number of hours estimated to complete the task.

Database Tables and Columns:

nbi_project_res_task_facts.etc_qty

Project Name

Displays the name of project to generate a report.

Database Tables and Columns:

nbi_project_current_facts. project_name

Resource Name

Displays the resource being reported.

Database Tables and Columns:

nbi_resource_facts.full_name

Start Date

Displays the start date for the task, phase, or milestone.

Database Tables and Columns:

prtask.prstart

Task Name

Displays a project task being reported.

Database Tables and Columns:

prtask.prname

Type

Displays if the report item is a task, milestone, or a phase.

Database Tables and Columns:

prtask.pristask, prtask.priskey, prtask.prismilestone

Variance

Displays the percentage of difference between the hours allocated for a project and the hours assigned to resources.

Calculation: ((Assigned Hours - Allocated Hours)/Allocated Hours).

Database Tables and Columns:

A calculated field. For more information, see the report SQL statement.