Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Resource Summary Report

3 replies [Last post]
Duncan Pirie
User offline. Last seen 10 years 2 weeks ago. Offline
Joined: 24 Sep 2012
Posts: 5
Groups: None

Hi,

 

relatively new to P6 and want to run a report that is similiar to the Resource Assignment. 

I have grouped my resources into different categories using Resource levels ie. Lvl 1 = Department, Lvl 2 = Department Breakdown, Lvl 3 = resources.

like image below

 

1278
capture1.jpg

 

What I want to do is produce a report to look the same, however I cannot get the totals to summarise.

See report below

1279
capture2.jpg

I have tried all sort od Total / Suammry check boxes, but can get this to work.

 

Anyone have any Ideas?

 

Thanks

 

Replies

Duncan Pirie
User offline. Last seen 10 years 2 weeks ago. Offline
Joined: 24 Sep 2012
Posts: 5
Groups: None

Thanks Jean,

I have been copying the reources into excel.  The only thing wrong with that is that it seems to copy the entire project i.e. from start to end date, so end up having to delete all the columns from excel.  Not a major thing, but just thought the report would be easier - If I could get it to work.

Many Thanks for your reply though.

 

Duncan

Jean Desjardins
User offline. Last seen 8 years 8 weeks ago. Offline
Joined: 7 Nov 2011
Posts: 23
Groups: None

Hi Duncan,

An option is to copy your informations with "Ctrl A" and paste it in an Excel spreadsheet.

Meanwhile, you will have to format your spreadsheet.

Jean

toan nguyen
User offline. Last seen 4 years 26 weeks ago. Offline
Joined: 28 Jul 2009
Posts: 5

please snet me native file, i can do it for you.