Skip to content

Primavera 5 Reporting

Grant PolatajkoMember for 23 years 4 months
Created
8
3
0
I need to create an "Activity Role and Resource Assignment"-type report that displays an Activity Code description as one of it’s columns. Is this possible?

8 replies

Oldest first
  1. 0
    Rodel Marasigan ·
    Yes it is possible. Click resource assignment icon directory toolbar (left side of your screen)
    Click Layout on the top or right click on your screen.
    Select Column-> Customise
    Select Activity codes or any required field available to display.
    Select File-> Preview once it’s done.

    You can also do this on the Report by creating a new report and follow the report wizard.

    Regards,
    Rodel
  2. 0
    Grant Polatajko ·
    Thanks for taking the time to reply Rodel.

    I have tried the methods you have suggested but in each case I am only able to see the Activity Code values and I require to see the associated Activity Code descriptions on this report. The code values are meaningless to the users of this report.

    Any other suggestions.

    Regards

    Grant
  3. 0
    Rodel Marasigan ·
    Try to group/ organised by activity code.

    Same thing right click and click column and select all the fields you want to show and click Ok.
    Right Click again and click Group & Sort-> customise
    Select the activity code and tick Show title, tick show code and un-tick show description and click Ok.

    I hope this will help.

    Regards,
    Rodel
  4. 0
    Grant Polatajko ·
    Thanks again Rodel

    I don’t want to group in this way. I really neeed the activity code description in the detail section of the output.

    Surely this is one of the reasons that we put code descriptions into the database, so that reports will make more sense.
  5. 0
    Rodel Marasigan ·
    The only way that I can think of is using ODBC link to database or use SQL to access PMDB database and link the table of ActvType to Task Table and RSRC Table to produce that report. These require a deep knowledge on Database/ ODBC link or SQL.

    Otherwise the best way is to export it in Excel and modify to suit your needs. You can do copy and paste function to speed up your work.

    I hope this help.

    Regards,
    Rodel
  6. 0
    Dieter Wambach ·
    Hi Grant,
    there is a way. Using the wizard you’ll create a report from the group "Resource and Role Assignments". You’ll include a column with that code value - give enough space for the decription.
    Now you’ll have to change to the Editor - icon at the right border of your screen.
    You’ll click onto this field, NOT onto the headline!
    Choose "Properties".
    Change the 2nd line ("cell object") to "activity name/"
    Change the 3rd line to "description"

    This should work

    Good luck
    Dieter
  7. 0
    Dieter Wambach ·
    Sorry,
    there was a mistake - some words skipped:
    Change the 2nd line to "activity Name, your code’s name"
    Dieter
  8. 0
    Grant Polatajko ·
    Thanks Dieter

    This works fine.

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?