98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Project Training and help » Custom Reports
Custom Reports
Resolved · High Priority · Version 2003
Christine has attended:
Project Intermediate course
Custom Reports
I have had some success in producing a custom report allowing me to see, under resource names, what work allocations a given employee has within a particular time frame. The problem is that I am choosing on the sort tab - name, WBS & project. However, when I print off the report, the ID number is clearly shown but the WBS is nowhere to be found. As we were hoping that the report could be given to people to not only outline what work they should be doing in the current and following week, we were also hoping that the WBS would be listed so that they could refer to it on their timesheets and enable us to track completed tasks.
I would also like to print off a sheet per resource name but am unable to achieve this at the moment either.
Please could you advise me if what I'm trying to do is feasible.
Many thanks
Christine van der Linden
RE: Custom Reports
Hi Christine
Thanks for the question. You can include the WBS field on custom reports based on the Task view not Resource. This is because the WBS is based on tasks. To create your report -
First create a table with the fields you would like
View, Table, More Tables
Click New
Then insert the 3 fields in order
Resource Names
WBS
Project
Give the table a name such as Resource Report
Now you should have a table on the screen with only those fields displayed.
Now to create the custom report...
Select View, Reports
Custom, click Select
Choose Task from the list of reports and click Edit
On the Sort tab pick asyou did before
Resource Names
WBS
Project
In the Details tab choose for the Table - Resource report
If you want a filter to choose a particular resource select:
Using Resource in the Filter option
Complicated but when you click Preview you should get a report with a prompt and Resource Names, WBS and Project
Hope that helps for now.
Doug Dunn
Best STL
Tue 17 Sep 2013: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
MS Project tip:Email a TaskWhen you need to communicate important information to your project staff use Microsoft Project 2003 to send them a note using outlook or an e-mail system. |