[email protected] +1.303.779.0344

Primavera P6 Status Report

Build a Gantt chart from Primavera P6 that color-codes your project based the status of each activity

OnePager can import one or more projects from Primavera P6 and color-code each task based on the Activity Status field, or any other User Defined Field or Global Activity Code that you use:

Project Status Report created in OnePager using a project from Primavera P6.

Free Trial

If you don't already have OnePager, click the button above to download a free trial. Then, follow these instructions to get started:

  1. Let's begin with a Primavera P6 project. In this example, we'll use the Activity Status field to track the status of each activity:

    Primavera P6 schedule showing the Activity Status field.

  2. Export the P6 schedule to either XML or XER format, both of which can be imported by OnePager. Go to File > Export and follow the steps to export the project:

    Export your Primavera P6 project to either XML or XER format.

  3. Now, launch OnePager from the desktop icon:

    Launch OnePager from your desktop.

  4. On OnePager's start screen, click on New to start building a new project status report from Primavera P6:

    OnePager start screen.

  5. When the import wizard appears, choose Select > BROWSE Primavera P6 Files, and then import the Primavera P6 XML or XER file that you created in the second step:

    Browse Primavera P6 XML or XER projects for import into OnePager.

  6. With your Primavera P6 file loaded, we want to pick a template for our project status report. On the import wizard, go to Change > BROWSE FILES and select the template called Multi-Resource Allocation View for Primavera. This template will automatically assign a different color to each task based on the value in the Activity Status field back in P6:

    Select the RAG status report template for Primavera P6.

  7. Give your Gantt chart a name, and then decide how you want to filter activities from P6. Because our sample project is relatively simple, we're just going to bring in all non-summary activities. If your Primavera P6 schedule is larger, you could choose to import only WBS-level summaries, or you could set up a user-defined field or global activity code, and filter on that instead:

    Filter your Primavera P6 schedule before importing it into a OnePager project status report.

  8. Click Create New Chart, and OnePager will import the activities from Primavera P6 to create a project status report, like this:

    Project Status (RAG) Report created in OnePager using activities from Primavera P6.

Free Trial

How it Works

OnePager uses its patented conditional formatting engine to assign colors based on the Primavera P6 activity status. Here's more detail on how the formatting is applied:

  1. Go to Home > Chart Properties > Task Bars and click on the Manage Rules button. Here, we see the conditional formatting rules that assign color based on the Activity Status field in Primavera P6:

    Create a sub-swimlane that looks at the Primavera P6 WBS.

    Activities that haven't started are red, activities that are in progress are orange, and activities that are complete are green. This is the traditional RAG (Red Amber Green) status report that many PMOs use on their projects.

  2. For added visility, we can add a hash fill pattern to each status as well. This is useful for people who are color blind and may not be able to distinguish between red and green:

    Add hash fill patterns on top of color in conditional formatting for a Primavera P6 schedule.

  3. Once the conditional formatting rules are reapplied, you'll see that each status has a unique color and hash fill pattern:

    Primavera P6 project status report with conditional formatting for color and hash fill pattern.

Build your own RAG status report from Primavera P6 today by downloading a free trial.

Free Trial