Skip to content

Reporting from many projects from the EPS

Brian WalkinMember for 8 years 9 months
Created
10
6
0

Hello,

I'm trying to produce reports for a group of unrelated schedules. I am using P6 Pro v20. Example provide a list of project names, start date and end date and % complete of all projects in the EPS by project type. Maybe pick out a few milestones with actual and baseline values and would only want to look at the cetrain versons e.g. current version and baseline of each schedule. If I can pull the data into a CSV file and create the reports outside P6 it would be better still.

Where to start, is this kind of thing possible from Reports within P6, are there any examples available online to look at. Will I need to get into the Database to do this kind of reporting. 

10 replies

Oldest first
  1. 0
    Rodel Marasigan ·

    Under the Project module, you

    Under the Project module, you can create a Project layout (grouping, sorting, filter, date,progress, etc) and produce the report. You may need to run the Tools -> Summarize to get the progress % shown.

  2. 0
    Brian Walkin ·

    Thanks to further clarify.If

    Thanks to further clarify.

    If one project has many schedules (wekly updates, What if's etc) in the EPS node how can we filter for the latest or most relevant schedule in each EPS to include.

  3. 0
    Rodel Marasigan ·

    You can filter by data date

    You can filter by data date or date added, which ever is your preference to suit your requirements.

  4. 0
    Rodel Marasigan ·

    .

    .

  5. 0
    Brian Walkin ·

    more clarification: would

    more clarification: would like to bring the data (data date, start date end date and last scheduled date) from the newest project in every EPS node. 

     

  6. 0
    Rodel Marasigan ·

    Yes, why not? If the

    Yes, why not? If the information are requires on the report. You can tailor to suit your report as per report requirement and what suits for the stakeholders.

  7. 0
    Santosh Bhat ·

    Brian, just like you can

    Brian, just like you can create Activity codes to assign to activities, you can create Project Codes to assign to projects. Select ENTERPRISE>PROJECT CODES from the menu. These can also be hierarchical.

    You can then Filter, or Group by these codes rather than using the EPS structure.

  8. 0
    Brian Walkin ·

    Santosh's suggestion to use

    Santosh's suggestion to use Select ENTERPRISE>PROJECT CODES takes care of part of my question. It is still necessary to ensure that the current version of the schedule for each project is tagged as master/working/current (which makes sense).

    One further question is whether it is possible to filter out one or more milestone activities from inside each schedule, e.g. Occupancy milestone, commissioning milestone or substantial completion etc. 

  9. 0
    Santosh Bhat ·

    Brian,Use a Global Activity

    Brian,

    Use a Global Activity Code to tag the required activities in each project. Then using the Project Codes, Open all the projects you have filtered at once., and then filter based on the Global Activity Code. 

  10. 0
    Rafael Davila ·

    It is not unusual to have

    It is not unusual to have hundreds of schedules in a government agency portfolio. If so, the program manager will be receiving hundreds of updates every month, each with a Data Date of their own, in some cases a few will not be received on time, but the manager will still be in need to report what is available. 

    Loading the latest update we know as Consolidation of Subprojects, it is done at a single click of the mouse.

    00

    This is a procedure many program managers must perform very frequently. Your software is different but I suspect there must be an easy way to automatically upload the latest update for each project schedule.

    If your software depends on pre-defined Financial Periods you might have some issues with the cost reports when the Projects Data Date and/or Performance Periods are different. It is possible that some submitted schedules might use weekly performance periods while other might use monthly performance periods or any other.

    Good Luck, Rafael

Log in or join to reply

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

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