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 this report if you work with project management.

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

Requirements

• At least one key task or milestone must be created on the project.
• Data for each WBS type, as selected in the parameters, displays if you have entered the appropriate data into the project schedule.
• To use the OBS Unit parameter to filter the report, at least one OBS must be added to the system and an OBS unit must be assigned to the programs or projects.

Parameters

Include Completed Tasks

Indicates if you want completed tasks included in report data.

Default: Cleared

Group By

Indicates how the information is to be grouped and presented on the report. Select an option from the drop-down to show how you want the information grouped.

OBS Unit

Indicates the OBS unit by which the report is filtered.

Print Late Items Only

Indicates if you want only items identified as late included in report data.

Default: Cleared

Project

Indicates the project or projects on which data is reported.

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 you want to see on the report. Select the option you want 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 that has been completed. This is a not a calculated field but is taken from a value users enter manually.

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 either the actual finish date or the date of the report if the finish has not occurred.

Database Tables and Columns:

This is a calculated field. For more information, see the report's SQL statement.

Performance

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

Database Tables and Columns:

This is a calculated field. For more information, see the report's 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 if the start has not occurred.

Database Tables and Columns:

This is a calculated field. For more information, see the report's SQL statement.

Task

Displays a project task being reported on.

Database Tables and Columns:

prtask.prname

Task Status

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

Database Tables and Columns:

prtask.prstatus

Type

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

Database Tables and Columns:

prtask.pristask, prtask.priskey, prtask.prismilestone