Skip to content
ProjectControls.com
Oracle Primavera - PM6

Primavera P6 Reports edit/format

In the Open Standard
Eamonn StauntonMember for 10 years 9 months
Created
6
3
0

Hi,

I can produce a report I need as a CSV file using the Reports in P6 but I am looking to edit/format it further. I produce the report every month but I am wondering if I can implement these edits within P6.

My report contains 10 columns of data each month and I make some changes to it after it runs and is produced as a CSV. I add in some extra columns which are slightly different to what I produce in P6.

For example, the report contains a column for 'Activity ID' like 1.1.1.1.3-014 for all my rows. After I produce the report, I add a new column called 'Primavera ID' - 1.1.1.1.3. This is the same as the Activity ID with out the '-014'.

There are many small changes like this that I make each month but I am ultimately wondering if I there is any functionality so I can include these in my report and then I will not have to make these changes each month after producing it?

Thanks!

Save Follow Follow forum Report
Reply New topic

6 replies

Oldest first
  1. 0
    Jerome Odeh ·
    #1

    Eamonn,Create a User Defined

    Eamonn,

    Create a User Defined Field called "Primavera ID" of Data Type "Text" and then apply Global Change. Under the Then section, add the formula

    Primaver ID = LeftString(Activity ID, 9)

    where 9 is the length of characters you want to keep from the example you gave and this assumes your activity IDs are all of same fixed length.

    Apply Global Change before running your report (remember to modify your report template to include this new field).

     

    =jerome
    http://plannerstips.blogspot.co.uk/

    Report
  2. 0
    Eamonn Staunton ·
    #2

    Thanks very much Jerome, I

    Thanks very much Jerome, I appreciate that!

    Can this also be done any alternative way? I know how to get the basics of what I need but would like to know more of the functionality, like could it be done in the Report Editor or is it only through using the steps you outlined above in relation to my original query?   

    Thanks

    Report
  3. 0
    Jerome Odeh ·
    #3

    Hi Eamonn,As far as I'm

    Hi Eamonn,

    As far as I'm aware, it cannot be done in Report editor.

    =jerome

    Report
  4. 0
    Eamonn Staunton ·
    #4

    Thanks v.much

    Thanks v.much

    Report
  5. 0
    Zoltan Palffy ·
    #5

    why dont you get your all of

    why dont you get your all of your columns set up in your data window and then right click and select export to excel. You can then use the trim function in excel to remove the -014. 

    Report
  6. 0
    Robert Corran ·
    #6

    Good Morning allI'm using P6

    Good Morning all

    I'm using P6 V16.2 I cannot get a report to come ut of it formatted as I want it. It is a simple report showing planned units for laboour and materials, when I export it to excel as an xls file as opposed to a csv file format, the data on each line is just one long line of text why?  In all previous P6 applications it ihas come in as a tabular report in the correct columns etc.

    The way I have got round it at themonment is to take the file extension off it, then dumo it into wordpad, the import the text file back into excel, seems a ponitless long winded way of doiong things, is there a setting somewhere I am missing

    Any help would be appreciated

    Thank you

     

    Rob

    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?