Skip to content
ProjectControls.com
Oracle Primavera - PM6

Primavera Report

In the Open Standard
Ismael MaksoudMember for 7 years 3 months
Created
5
1
0

Dear All,

I have 20 projects, each with 10 activities.

I need a reprot to show the first "not started" activity ONLY of each project in the 20 projects.

I mean I need a reprot of the first record of not started activity so in total it should be 20 lines.

Appreciate your feedback,

Ismael

Save Follow Follow forum Report
Reply New topic

5 replies

Oldest first
  1. 0
    Santosh Bhat ·
    #1

    Open all projects, group by

    Open all projects, group by project as 1st level of grouping and then by activity status as 2nd level of grouping. Apply a filter to only select activities with activiry status equals not-started. Then collapse to r6he second grouping band. While this will display *all* bot started activities, it will be a report of only 20 lines and is the easiest way to produce this without needing complicated coding and filtering.
    Report
  2. 0
    Ismael Maksoud ·
    #2

    This showed all "not" started

    This showed all "not" started activities not the first one only. It showed 100 lines as each project has 5 uncompleted activities.
    Report
  3. 0
    Kevin Button ·
    #3

    I would group activities as

    I would group activities as Santosh has suggested and sort by ES date, then copy-paste into Excel and delete all but the first activity of each project.  This should take only a minute or two.
    Unless of course you need to report directly from P6, in which case you would need a fancy filter.

    Cheers, KB
     

    Report
  4. 0
    Santosh Bhat ·
    #4

    Ismael, Primavera has no

    Ismael, Primavera has no ability to directly show only the first non-started activity. you would need extra coding and filtering to achieve this as I mentioned in my previous post.

    To remove the 100 lines down to 20 you need to collapse to the second level - however this will indeed show all 100 activities, but collapse them down to one grouping band per project.

     

    Report
  5. 0
    Zoltan Palffy ·
    #5

    they are correctmake a global

    they are correct

    make a global code call it my20 and give it a code value of 20

    now go into each project and filter where activity status equals NOT STARTED

    no sort by start date and assign the my20 code to the 1st activivity

    no do this 19 more times for the other projects

    then open all 19 projects and filter for the code 

    where my20 equals 20

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?