Crystal Reports › Program Schedule Review Report

Program Schedule Review Report

Description

This report provides a Gantt chart of the projects within a program, including milestones. The report lists the full or summary detail, and identifies inter-project dependencies.

Prerequisites

• Define a program.
• Active projects under a program required with start and finish dates and status and risk fields defined.
• Detailed work breakdown structure required with milestones for the project tasks.

See the Project Management User Guide for more information.

Parameters

Report Name

Indicates the names of the report.

Program Name

Defines the name of the program for the report.

Starting Month

Indicates the starting month for the report.

Starting Year

Defines the starting year for the report.

Level of Detail

Specifies the level of task detail to generate in the report.

Values: Full WBS, Milestones Only, Summary Only

Type of Period

Indicates the type of periods to generate in the report.

Values: Monthly, Semi-Annually

Report Fields

Program Name

Displays the program name for the report.

Database Tables and Columns:

inv_investments.name

Program ID

Displays the unique ID for the program.

Database Tables and Columns:

inv_investments.code

Description

Displays the program description.

Database Tables and Columns:

inv_investments.description

Start Date

Displays the start date for the program.

Database Tables and Columns:

inv_investments.schedule_start

Finish Date

Displays the finish date for the program.

Database Tables and Columns:

inv_investments.schedule_finish

Base Start

Displays the baseline start date for the program.

Database Tables and Columns:

prj_baseline_details.start_date

Base Finish

Displays the baseline end date for the program.

Database Tables and Columns:

prj_baseline_details.finish_date

Status

Displays the program schedule status (Green, Yellow, or Red)

Database Tables and Columns:

odf_project_v2.status_indicator

Risk

Displays the program risk status.

Database Tables and Columns:

case

when niku.cmn_null_int_fct(odf_project_v2.risk,

-1) = -1

then 0

when niku.cmn_null_int_fct(odf_project_v2.risk,

-1) <= 33

then 1

when niku.cmn_null_int_fct(odf_project_v2.risk,

-1) > 67

then 3

when niku.cmn_null_int_fct(odf_project_v2.risk,

-1) > 33

then 2

else 0

end

Stage

Displays the current stage of the program.

Database Tables and Columns:

inv_investments.stage_code

WBS

Displays the work breakdown structure for the program.

Database Tables and Columns:

prtask.prname

Status/Risk

Displays the status of risk for the current program.

Database Tables and Columns:

odf_project_v2.status_indicator /

case

when niku.cmn_null_int_fct(odf_project_v2.risk,

-1) = -1

then 0

when niku.cmn_null_int_fct(odf_project_v2.risk,

-1) <= 33

then 1

when niku.cmn_null_int_fct(odf_project_v2.risk,

-1) > 67

then 3

when niku.cmn_null_int_fct(odf_project_v2.risk,

-1) > 33

then 2

else 0

end

Project Name

Displays the project name.

Database Tables and Columns:

inv_investments.name

Finish Date

Displays the finish date of the project.

Database Tables and Columns:

prtask.prfinish

More information:

Access to Crystal Reports