Skip to main content
Planview Customer Success Center

Portfolio Project Status

This report show a portfolio of projects with key status information. For example, list the projects included in each of your portfolios along with their status, % complete, overall health, and other key information. You can build this report using the design settings in the table below. Alternatively, you can download this report definition and upload it to your PPM Pro instance. Please note that if you download the report definition file, the user-defined field in this example will not be in your instance and you will need to select an appropriate replacement in the resulting report.

port proj status.png

Design View Selection Comments
General

Topic: Portfolio

Type: List: Basic

Title: <enter a meaningful title>

 

You can also simply set the Topic to Project if you want to show projects without regard to portfolio, or, just show this information for a single project. When doing this, omit the Portfolio Data fields.

Data

List Fields: Whichever of the following and others would be of value, such as

  • Portfolio > Title
  • Portfolio > Projects: Linked to Portfolio > Title
    • Change Display Name to "Project"
  • Portfolio > Projects: Linked to Portfolio > Owner
    • Change Display Name to "Owner"
  • Portfolio > Projects: Linked to Portfolio > Investment Type
    • Change Display Name to "Type"
  • Portfolio > Projects: Linked to Portfolio > Status
    • Change Display Name to "Status"
  • Portfolio > Projects: Linked to Portfolio > Target Date
    • Change Display Name to "Target Date"
  • Portfolio > Projects: Linked to Portfolio > % Complete
    • Change Display Name to "% Complete"
  • Portfolio > Projects: Linked to Portfolio > Budget Cost
    • Change Display Name to "Budget Cost"
  • Portfolio > Projects: Linked to Portfolio > Total Actual Cost
    • Change Display Name to "Actual Cost"
  • Portfolio > Projects: Linked to Portfolio > Overall RAG
    • Change Display Name to "Overall RAG"

When starting with the Portfolio topic you will need to select the field path Portfolio > Projects: Linked to Portfolio to get to the project available fields. For example:

Screen Shot 2020-07-05 at 8.59.39 PM.png

This report is an example showing one user-defined field "Overall RAG". Please note that if you download the report definition file, this user-defined field will not be in your instance and you will need to select an appropriate replacement in the resulting report. Further, you may want to replace the "Total Actual Cost" standard field with "Total Actuals (Financial Summary)" standard field if the Financial Summary is in use for these projects (and possibly add other Financial Summary fields such as "Total Budget (Financial Summary)" and "Total Forecast (Financial Summary)").

Display and Preview List Columns

Configure desired options within the Display tab, such as Grouping, Sorting, Drilldown, or Aggregation.

Within the Preview pane, select each column's options menu to set specific display options such as:

  • For lookup list fields that have colors or icons configured, optionally set "Display Data As" such as "Value on top of Color" for Status or "Colored Icon" for Overall RAG
  • For date fields, optionally set "Display Data As" to a desired format such as "dd-MMM-yyyy" for Target Date
  • For monetary fields, optionally set "Display Data As" to show or hide decimal values such as "$0,000" for Budget Cost and Actual Cost
Screen Shot 2020-07-05 at 9.09.07 PM.png
Variable Settings

Scope: Portfolio

Filters: optionally include portfolio or project filters

 

Selecting the Portfolio Scope will cause this report to be available on Portfolio Report grids so it can be run for associated portfolios. You can select other Scope options if you want this report to be shown in other entity grids as well.

As needed, you can also include Filters.

If you want to allow the user to change to a different Scope and/or Filter before running the report or when viewing the report, select the relevant checkboxes for Allow changing.