Crystal Reports › Resource Availability Report

Resource Availability Report

Description

This report lists resources on projects and shows their total allocations or assignments over a specified time period.

The first section of this report lists the resource names and their resource roles (primary role) sorted alphabetically based on resource name. The second section lists the number of hours available for each resource based on the reporting periods selected. Total available hours display on a per resource basis (row-by-row) and by period (column).

Prerequisites:

• Active projects must exist staffed with active resources.
• Allocate and assign active resources to the specific active projects.

Parameters

OBS Unit

Indicates the OBS unit to filter the report.

Report Name

Indicates the names of the report.

Resource OBS

Indicates the OBS unit that filters the report. Click the Browse icon and select OBS from the list that appears.

Report Periods

Defines the time periods for data to display in the report.

Values: months or weeks

Starting Date

Indicates the starting date for the data displayed in this report.

Resource Role

Displays the role for the associated resource.

Resource Manager

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

Report Fields

Resource Name

Displays the full name of the resource.

Database Tables and Columns:

srm_resources.last_name

srm_resources.first_name

Resource Role

Displays the role for the associated resource.

Database Tables and Columns:

srm_resources.full_name

Role Name

Displays the role name.

Database Tables and Columns:

srm_resources.full_name where prj_resources.prprimaryroleid = srm_resources.id

Availability

Displays the availability (Available - Total Demand) for the associated resource.

Database Tables and Columns:

prj_blb_slices.slice where slice_request_id = (select id from prj_blb_slicerequests

where request_name like 'dailyresourceavailcurve')

More information:

Access to Crystal Reports