jrjohnosn5
Technical User
I need to pull a completed tasks report from multiple project files. Does anyone know how to do this? We use a mix of Project 2000 and Project 2003.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Print a report based on multiple projects
- Thread starter jrjohnosn5
- Start date
- Status
Open project
Start with a blank project
For each project:
Click on Insert | Project... and navigate to the file.
(I'd leave the "link to project" box with a checkmark.)
When you have selected all the projects, then click on View | Reports and double-click on "Current Activities" then double-click on "Completed Tasks".
This is such a simple task that I suspect you are either looking for a solution to a homework assignment (in which case: silly me for doing it for you) or have more complex requirements (in which case: post them).
Start with a blank project
For each project:
Click on Insert | Project... and navigate to the file.
(I'd leave the "link to project" box with a checkmark.)
When you have selected all the projects, then click on View | Reports and double-click on "Current Activities" then double-click on "Completed Tasks".
This is such a simple task that I suspect you are either looking for a solution to a homework assignment (in which case: silly me for doing it for you) or have more complex requirements (in which case: post them).
- Thread starter
- #3
jrjohnosn5
Technical User
I apologize if my question is too simple for you. I am a new user, taksed with figuring out how to get a report for my boss. I alos have many other things to do and do not have as much time to play around with this as I would like. I had attempted what you said (based on previous postings) and the report did not come up with any information. I then discovered (on my own) that I had to expand each project before that report would run. Now that I can run the report I am attempting to figure out how to sort it by the main task and list the subtasks underneath. I haven't gotten exactly what I need yet, but I am closer than I was.
What I also need is a report that shows the name of the project and the name of the last completed task. If you know of a report that does that I would appreciate the help.
What I also need is a report that shows the name of the project and the name of the last completed task. If you know of a report that does that I would appreciate the help.
Grasshopper, you ask much.
1. Set up the display.
1a Display the Project column
1b Display the Flag1 column
1c Click on the AutoFilter button so it is depressed.
2. Display just the tasks you want.
2a Click on Tools | Options | View-tab, clear the checkbox named "Show Summary Tasks" , click on OK.
2b Click on the filter and select "Completed Tasks"
2c Click on Project | Sort | Sort By... to display a popup. In the first item select "Finish" and click on the Descending radiobutton.
3. In the Flag1 column select "yes" for the tasks you specifically want to display and "no" for those you don't want to display.
4. Click on the downward pointing arrow at the top of the Flag1 column and choose "Yes".
5. Now, resort the report to get the tasks within the Project. Click on Project | Sort | Sort by... and in the first item choose Project and ascending and in the second item choose Finish and either ascending or descending.
6. Click on File | Print Preview... and you'll see your report.
Hmm. Not so difficult after all.
Yes, yes, I know: it's a bit cumbersome and there are more elegant ways to do this but this can be done quickly, easily and gives you exactly what you asked for along with some flexibility in choosing exactly which tasks you select for each inserted project.
1. Set up the display.
1a Display the Project column
1b Display the Flag1 column
1c Click on the AutoFilter button so it is depressed.
2. Display just the tasks you want.
2a Click on Tools | Options | View-tab, clear the checkbox named "Show Summary Tasks" , click on OK.
2b Click on the filter and select "Completed Tasks"
2c Click on Project | Sort | Sort By... to display a popup. In the first item select "Finish" and click on the Descending radiobutton.
3. In the Flag1 column select "yes" for the tasks you specifically want to display and "no" for those you don't want to display.
4. Click on the downward pointing arrow at the top of the Flag1 column and choose "Yes".
5. Now, resort the report to get the tasks within the Project. Click on Project | Sort | Sort by... and in the first item choose Project and ascending and in the second item choose Finish and either ascending or descending.
6. Click on File | Print Preview... and you'll see your report.
Hmm. Not so difficult after all.
Yes, yes, I know: it's a bit cumbersome and there are more elegant ways to do this but this can be done quickly, easily and gives you exactly what you asked for along with some flexibility in choosing exactly which tasks you select for each inserted project.
- Status