Skip to content

Resource Usage Report

David BladesMember for 22 years 6 months
Created
4
1
0
I have set up a resource usage report. When exported to excel the resources are down the left hand column and the usage dates spread across top rows.

I added the column ’max units/time’ to allow me to see shortages however for some reason that column is not popuated with the limit levels despite the fact that there are in the resource dictionary??

Thanks in advance for any assistance

4 replies

Oldest first
  1. 0
    Rodel Marasigan ·
    David,
    What subject did you select when setting up the report? I just run a Activity resource & roles assignment with Max unit/time column added and it has all the data.
  2. 0
    David Blades ·
    Hi Rodel, I have chosen the same? Under columns all I have is Activity name and Max Units/Time. Group and Sort I have Resource ID name. Filter I have where open state equals open AND Resource type equals nonlabor (whichis what I need. Time interval period I have budgeted units?

    I’ll keeping trying meantime, many thanks
  3. 0
    David Blades ·
    Rodel.... it appears to be something to do with the ’show summaries only’ tick box within group and sort?
    When ticked the max units/time data is not on the report, when not ticked the data is there. Only problem is that I only require the summary list... do you know anyway around this?

    Thanks in advance
  4. 0
    Rodel Marasigan ·
    David,
    Unfortunately max Unit/Time will not average or show in the summary band. It is like a text that will not summarize. If you need to show them use the detail report and run pivot table on excel. That would help.

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?