Crystal Reports Stock Report Descriptions › Key Tasks and Milestone Status Report

Key Tasks and Milestone Status Report

Description

This report provides a status and variance for project key tasks, milestones, phases, or the full work breakdown structure. The pie chart compares late and on time task starts and finishes.

Run the report to work with project management.

Note: See the Project Management User Guide for more information.

Requirements

• At least one key task or milestone requires creating on the project.
• If you enter the appropriate data into the project schedule, data displays for each WBS type, as selected in the parameters.
• To filter using the OBS Unit parameter, add at least one OBS to the system. In Addition, assign an OBS unit to the programs or projects.

Parameters

Include Completed Tasks

Indicates to include completed tasks in report data.

Default: Cleared

Group By

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

OBS Unit

Indicates the OBS unit by which the report is filtered.

Print Late Items Only

Indicates to include items identified as late in report data.

Default: Cleared

Project

Indicates the projects to generate the report.

Threshold

Indicates the number of days that pass before a project shows a yellow or red stoplight status.

WBS Type

Indicates the level of WBS data to display on the report. Select the option from the drop-down list.

Charts

Two pie charts indicate the number of late starts and finishes compared to on-time starts and finishes.

Report Fields

% Complete

Displays the portion of the task, milestone, or phase completed. This field is a not calculated, but is shown as the user specifies.

Database Tables and Columns:

prtask.prpctcomplete

Finish Date

Displays the finish date for the task.

Database Tables and Columns:

prtask.prfinish

Finish Variance

Displays any difference between the planned finish date and the actual finish date, or the date of the report.

Database Tables and Columns:

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

Performance

Displays through stoplights the performance for the task, milestone, or phase according to the threshold set.

Database Tables and Columns:

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

Start Date

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

Database Tables and Columns:

prtask.prstart

Start Variance

Displays the difference between the planned start date and the actual start date, or the date of the report.

Database Tables and Columns:

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

Task

Displays a project task being reported.

Database Tables and Columns:

prtask.prname

Task Status

Displays if a task, milestone, or phase is started, not started, or complete.

Database Tables and Columns:

prtask.prstatus

Type

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

Database Tables and Columns:

prtask.pristask, prtask.priskey, prtask.prismilestone