Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

custom reports

ResolvedVersion 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.

MS Project tip:

Change default view – Project 2010

a. In Project, click on the File tab
b. Select General from left hand side (this should be the screen displayed by default)
c. Set the Default view dropdown box to your chosen option
d. Click OK to apply your changes

View all MS Project hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.