Re: Admin Projects and Tracking time
From: Dale Howard [MVP] ("Dale)
Date: 01/19/05
- Next message: Astroboy: "Baselines in imported projects"
- Previous message: Dale Howard [MVP]: "Re: commands dialog hidden in Portfolio Analyser view"
- In reply to: baylort_at_mtiinfotech.com: "Re: Admin Projects and Tracking time"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 19 Jan 2005 13:48:35 -0700
Travis --
You cannot create a custom Resource Usage report that shows each resource
and only the tasks in the active project. The reason for this is because
the Resource Usage view shows assignments across all projects in the system.
On the other hand, you can create a custom Group and apply it to the Task
Usage view so that it makes this view look like the Task Usage view. Using
this trick, you can create a View that looks like Resource Usage but shows
only assignments in the active project. Here's how:
1. Open the administrative project
2. Click Project - Group by - More Groups
3. Click the New button
4. Name the new Group "_Group by Resource Assignments" and select the Show
in menu option
5. Select the "Group by assignments, not tasks" option below the data grid
6. On the Group By line, select the Name field and set the Field Type as
Assignment
7. On the Then By line, select the Name field and set the Field Type as
Task
8. Click the OK button
9. Apply your new Group to the Task Usage view
10. Click the Show button on the Formatting toolbar and select Outline
Level
Once you have applied the Group to the Task Usage view, it looks like the
Resource Usage view. You can now zoom the timescale to Months Over Weeks
and then print the View. Hope this helps.
-- Dale A. Howard [MVP] Enterprise Project Trainer/Consultant http://www.msprojectexperts.com "We wrote the book on Project Server" <baylort@mtiinfotech.com> wrote in message news:1106154662.377031.152420@f14g2000cwb.googlegroups.com... > Dale-- > > Thanks again for the help. However after looking at this report I > have one more question. Is there any way to have a report just lie the > one below that shows the resources instead of tasks. When I try and do > this I see work from the other projects not just the admin project. Is > there any way to see time broken down by resource just for the admin > project? > > ---Travis > > > > Dale Howard [MVP] dot at dot wrote: >> Travis -- >> >> Do the following: >> >> 1. Open Microsoft Project and open the admin project >> 2. Click View - Reports >> 3. Double-click the Custom option >> 4. Select the Task Usage report and click the Copy button >> 5. Give your custom Report a new name >> 6. Replace the Work field with the Actual Work field in the > Crosstabsection >> of the dialog >> 7. Click OK and then click Close >> 8. Click Tools - Organizer - Reports >> 9. Copy the new Report to your Global.mpt file >> 10. Click the Close button >> > >> You can view and print this report at any time by clicking View - > Reports - >> Custom, selecting your new Report, and clicking the Print Preview > button. >> If everyone needs to use this Report, your Project Server > administrator >> should open your admin project and copy the new report to the > Enterprise >> Global file using Tools - Organizer. Hope this helps. >> >> -- >> Dale A. Howard [MVP] >> Enterprise Project Trainer/Consultant >> http://www.msprojectexperts.com >> "We wrote the book on Project Server" >> >> >> <baylort@mtiinfotech.com> wrote in message >> news:1106140725.002327.184330@f14g2000cwb.googlegroups.com... >> > Dale--- >> > >> > Thanks for the insight. I was leaning towards using that view, i > just >> > wanted to try and view it using PWA. Could you give any insight on > how >> > to create a report that shows just the admin project and the hours > each >> > resource worked, using the reports? Thanks again for your help. >> > >> > Travis >> > >> > >> > >> > Dale Howard [MVP] (dot at dot) wrote: >> >> Travis -- >> >> >> >> You might try the following steps: >> >> >> >> 1. Open the project in Microsoft Project Professional >> >> 2. Click View - Task Usage >> >> 3. Adjust the level of zoom for the timephased grid to Months > Over >> > Weeks >> >> >> >> In the Table on the left side of the View, you will be able to see >> > each task >> >> and the resources assigned. In the timephased grid on the right, > you >> > will >> >> be able to see he amount of hours submitted for the week. Hope > this >> > helps. >> >> >> >> -- >> >> Dale A. Howard [MVP] >> >> Enterprise Project Trainer/Consultant >> >> http://www.msprojectexperts.com >> >> "We wrote the book on Project Server" >> >> >> >> >> >> <baylort@mtiinfotech.com> wrote in message >> >> news:1106054046.515431.100750@c13g2000cwb.googlegroups.com... >> >> >I know about the resources adjust actuals on the web, however it >> > takes >> >> > a while to load with all the other projects and we only need to > see >> > the >> >> > admin project, because we don't report time worked on the other >> >> > projects, just % complete. We are going to be using the admin >> > project >> >> > to track all time and i want to be able to view just this > project >> > in a >> >> > central location, where i can view total hours worked on each > task >> > and >> >> > by each resource. Is there any way to do this??? >> >> > >> >> > Travis >> >> > >> >> > >> >> > >> >> > Patrick wrote: >> >> >> On the web, under the Resources- Adjust actuals option I am > able >> > to >> >> > see by >> >> >> the selection criteria and filtering options based on what's >> > desired >> >> > (sort by >> >> >> Project, Resource, etc) a report that can be exported to Excel. >> >> >> >> >> >> "baylort@mtiinfotech.com" wrote: >> >> >> >> >> >> > I have set up a administrative project so all of our > resources >> > can >> >> >> > acount for all of their time, be project or non-project > related. >> >> > Now >> >> >> > how can I view the total hours worked each week on each task > (or >> >> >> > project). I need to allow our accounting people access to > this >> > view >> >> > in >> >> >> > order to create reports and bill clients. Is there any way to > do >> >> >> > this??? >> >> >> > >> >> >> > Travis >> >> >> > >> >> >> > >> >> > >> > >
- Next message: Astroboy: "Baselines in imported projects"
- Previous message: Dale Howard [MVP]: "Re: commands dialog hidden in Portfolio Analyser view"
- In reply to: baylort_at_mtiinfotech.com: "Re: Admin Projects and Tracking time"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
