Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Highlight individual activities in Primavera P6 report

In primavera P6 report, they do not support to highlight individual activity which we want, such as activity behind schedule. Now, I will share with you one way to do this. And in this demo, I want to highlight activity has Total Float (TF) and Variance -BL Project Finish Date (Variance) to red if their value is less than or equal zero to alert for Project Manager and Contractor,

1. First, Right click on report/choose Modify,

2. In Report editor layout, at Detail Area, right click, choose Add Row,

5533
picture_2.jpg

3. Next, copy all cell from first row to new second row below,

5534
picture_1.2.jpg

4. In the second row, double click (or right click/Property) at cell Total Float and Variance, at Font style, choose Custom, and at Custom Font, choose Red color.

5535
picture_2.jpg

5. Now, to indicate Total Float and Variance-BL Project Finish Date  in red in case of their value is less than or equal to zero, Click on Row tab, at Edit filter, set TF and Variance to indicate only if their value equal or less than zero. Click OK to close filter window.

5537
picture_3.png

6. To indicate if TF and Variance above zero (ahead) is in black (default color). In first row, double click (or right click/Property) at cell TF and Variance, choose Row tab, at Edit filter, set TF and Variance to indicate only if their value greater than zero.

5538
picture_4.png

The defaut color is black, so in the first row, we don't need to change the color of TF and Variance cell. It shall indicate black if their filter value is met.

7. Now, after completing all setting, click on Priview button above to see the report and edit/alight position of cell if any before saving and closing report.

5541
report_1.png

Now, we have a report which we want to highligh activity behind schedule or something like that. Thanks for your reading and give me any comments to improve this topic.

Thanks,

Market Place

Primavera P6 and Microsoft Project books, on-line video training courses and training material available from an internationally recognised publisher. Teach yourself using on-line or book based learning or run your own in-house or public courses.