Removing completed tasks from Project Web view

[aho200]

Is there a way for a project manager to remove completed tasks from the team
member's project web view of their tasks? I would like to do this for the
resources and not have them have to manually hide each tasks in the Project
Web view or to require that they use a filter to show only incomplete tasks.
I do not want to delete the tasks in project or the resources because of
actual worked hours values stored there. Setting the tasks in project to
100% complete or 100% work complete and republishing the tasks did not work.
Thanks.

 

[Dale Howard [MVP]]

aho200 --

Your Project Server administrator can delete completed tasks from each
user's PWA timesheet by going to Admin - Clean Up Project Server Database.
He/she can select the Tasks option and then select Completed Tasks only. A
project manager cannot do this unless he/she has administrator permissions.
Hope this helps.

 

[Hugues Perron]

Hi,

If you don't want to delete the tasks and are not afraid to do some
little modifications to the database, you can refer to the guide

How to close a task (Project Server 2003).doc

you can find it here

http://hperron.net/index.php?option=com_docman&task=cat_view&gid=17&Itemid=30

But as I said, this implies to modify the database, so be very carefull
if you do so.

Hope this helps

Hugues

aho200 a écrit :

 

[Scott Morrissey]

Dale,
If you do this, won't the tasks re-appear in PWA the next time the
project is published? Also, won't this be mis-leading to team members? When
they go to all tasks in previous weeks, they won't see the work that they did
if these tasks are deleted.

I wish the product had a good way of keeping completed tasks on timesheets -
but dis-allow any further actuals to be posted to it.

 

[Dale Howard [MVP]]

Scott --

No, the tasks will NOT reappear unless the project manager republishes the
assignments using Collaborate - Publish - Republish Assignments. After
updating actuals into the project from the Updates page in PWA, the project
manager should publish the latest schedule changes using Collaborate -
Publish - All Information. There is no need to republish the assignments.
In fact, the republishing of assignments should only be done in one of the
following situations:

1. To take over as the manager of another manager's project, either
temporarily or permanently
2. To "push" actuals to each user's PWA timesheet after manually entering
actuals in the Microsoft Project plan
3. To "push" a new method of tracking to each user's timesheet
4. To "unhide" a task accidentally hidden by a team member

In scenario #4 above, the project manager should first apply the Resource
Usage view, select the task that was accidentally hidden, click
Collaborate - Publish - Republish Assignments, and select the "Selected
Tasks" option from the top of the dialog.

 

[Aileen_H]

Our administrator and I just tested this cleanup function in our test
environment. It deletes the actual hours stored in the PWA database.
Currently, our custom Crystal Reports pull data from our PWA database. We
wrote custom Crystal reports that pull across all projects from PWA instead
of the Project Server Database because we only had the schema for PWA. Is it
possible to get a schema for Project Server 2003 so that we may perhaps
rewrite our reports to pull from there instead of from PWA? This would then
allow us to cleanup PWA completed tasks. Thanks.

 

[Dale Howard [MVP]]

Aileen H --

The cleanup function does not delete the actuals from the Microsoft Project
plan, so you can still report on those actuals. Refer to the following for
the schemas of both Microsoft Project and Project Web Access:

http://www.microsoft.com/downloads/...c2-3ac1-4fc8-8e67-d908cdb9faf2&DisplayLang=en

http://www.microsoft.com/downloads/...75-1367-4b66-870d-f280c054efe2&DisplayLang=en

Hope this helps.

 

[Aileen_H]

Dale,

Sorry. I just noticed you did provide the schema links. Many thanks.

Aileen