Select "Summary Resource Assignments" for your Selected Subject Area.
Click COLUMNS
Select from Available... Role or Resource depending on the level you wish to report at. I also select Budgeted Units
Click GROUP AND SORT
You will need to tick Show Grand Totals and Show Summaries Only.
Group by... "Role level 1" (or suitable resource level) To Level "All"
Click FILTER
Apply a suitable filter for your needs. If you only have open those projects you want to report on then you will not need a filter.
Click NEXT
Click Timescale
Im sure you can work this one out!
Click NEXT
Tick Show Time intervals and Show Period Total
Click Time Interval Fields
Select the fields you want to appear in your matrix. I selected Budgeted Units, Cum Budgeted Units, Budgeted Cost and Cum Budgeted Cost. ( you can edit the column heading here if you want...)
Click NEXT
Give your report a title.
Click NEXT
Click Run Report
Select your output destination. I suggest Print Preview at first!
Once you are happy with what youre getting select ASCII Text File. Excel should be invoked when the report has run to show you your data.
Phew!
Member for
19 years 3 months
Member for19 years4 months
Submitted by Paul Naughton on Fri, 2006-11-24 07:08
Ah, I take it you just want the "raw" data rather than it be laid out in context?
I have a report that will list the resource down the left column, time periods accross the top (days, weeks, whatever) and the matrix within is populated by the Labour Units in hours, the same cumulative, the Labour Cost and the same cumulative...
23/10/06 30/10/06 06/11/06
Designer Units 4h 5h 5h
CumUnit 4h 9h 14h
Cost £76 £95 £95
CostCum £76 £171 £266
... and so on.
Is this what you are after?
Member for
19 years 3 months
Member for19 years4 months
Submitted by Paul Naughton on Fri, 2006-11-24 06:40
The problem is getting it into excel, Ive used ASCII format and then text to columns in excel but itis not idea.
I have my resources set hierachical and when I print the report it is giving me all the parent legs which are of no use, if you know a way to get the report without these it would be a help.
Paul
Member for
19 years 6 months
Member for19 years6 months
Submitted by David Podmore on Fri, 2006-11-24 06:36
There are number of standard reports in P3e (P5) that should do the trick. I suggest using the Wizard to guide you through the options and just have a play. The output will, by default, be displayed on screen but you can redirect this to a printer, HTML or a ASCII text file in comma separated variable format.
You will need to select Timephased data to get a table.
Member for
21 years 1 monthRE: Tabular Reports
in P3e,
the best way to write a report is,
go to the view you want, either in project view,
tracking view, resource assignment view, what ever views that you are after.
adjust your columns etc, adjusted your time distrubuted line etc..
then, click on menu bar,
TOOLS --> Report Wizards,
and at the radio button ,,, click "Use current screen"
-------------------------
that way, you will get the report you wanted. instead of playing around with the other things.
regards,
Vu Dang
www.dangcorp.com
Member for
22 years 8 monthsRE: Tabular Reports
Just a suggestion @ the very end to create the file
What you can do is to create a .CSV file and Excel will open it automatically without and trouble at all
Cheers
Alex
Member for
19 years 6 monthsRE: Tabular Reports
Here goes...
Run Report Wizard
Select "Summary Resource Assignments" for your Selected Subject Area.
Click COLUMNS
Select from Available... Role or Resource depending on the level you wish to report at. I also select Budgeted Units
Click GROUP AND SORT
You will need to tick Show Grand Totals and Show Summaries Only.
Group by... "Role level 1" (or suitable resource level) To Level "All"
Click FILTER
Apply a suitable filter for your needs. If you only have open those projects you want to report on then you will not need a filter.
Click NEXT
Click Timescale
Im sure you can work this one out!
Click NEXT
Tick Show Time intervals and Show Period Total
Click Time Interval Fields
Select the fields you want to appear in your matrix. I selected Budgeted Units, Cum Budgeted Units, Budgeted Cost and Cum Budgeted Cost. ( you can edit the column heading here if you want...)
Click NEXT
Give your report a title.
Click NEXT
Click Run Report
Select your output destination. I suggest Print Preview at first!
Once you are happy with what youre getting select ASCII Text File. Excel should be invoked when the report has run to show you your data.
Phew!
Member for
19 years 3 monthsRE: Tabular Reports
Thanks
Member for
19 years 6 monthsRE: Tabular Reports
:) OK. Ill try and write a "how to" today and post it. Might take a bit of typing! Bear with me...
David
Member for
19 years 3 monthsRE: Tabular Reports
That sounds like just what Im after
Member for
19 years 6 monthsRE: Tabular Reports
Ah, I take it you just want the "raw" data rather than it be laid out in context?
I have a report that will list the resource down the left column, time periods accross the top (days, weeks, whatever) and the matrix within is populated by the Labour Units in hours, the same cumulative, the Labour Cost and the same cumulative...
23/10/06 30/10/06 06/11/06
Designer Units 4h 5h 5h
CumUnit 4h 9h 14h
Cost £76 £95 £95
CostCum £76 £171 £266
... and so on.
Is this what you are after?
Member for
19 years 3 monthsRE: Tabular Reports
Thanks David,
The problem is getting it into excel, Ive used ASCII format and then text to columns in excel but itis not idea.
I have my resources set hierachical and when I print the report it is giving me all the parent legs which are of no use, if you know a way to get the report without these it would be a help.
Paul
Member for
19 years 6 monthsRE: Tabular Reports
Hi Paul,
There are number of standard reports in P3e (P5) that should do the trick. I suggest using the Wizard to guide you through the options and just have a play. The output will, by default, be displayed on screen but you can redirect this to a printer, HTML or a ASCII text file in comma separated variable format.
You will need to select Timephased data to get a table.
David