Re: who does when what report

From: Arun (anonymous_at_discussions.microsoft.com)
Date: 03/05/04 

Date: Fri, 5 Mar 2004 04:41:09 -0800

Hi,

I am able to short list the task but in this method a couple of task which have actuals booked in the specified period gets missed out.
The scenario is this. I have 10 tasks named from task1 to task10. i want to list the task name along with the actual hours booked for a period irrespective of their start and end dates. if for the period 16-feb to 20feb i have only the actuals entered against task1, task6, task8 then i need to display only these 3 tasks..

is there anything i need to include in the filter criteria.?

thanks.

     ----- John Beamish wrote: -----
     
     The Who Does What When report uses the filter "Resources - Work"
     
     First, build the appropriate filter:
     
     1. Project | Filtered for | More filters ...
     2. Click on the Resource radio button
     3. Click on "Resources - Work"
     4. Click on Copy
     
     There is already one filter condition being applied. We have to add
     several additional ones.
     
     5. add a row
     And/Or = And
     Field Name = Actual Work
     Test = is greater than
     Values = 0h
     
     6. Add a row
     And/Or = And
     Field Name = Start
     Test = is greater than
     Values = "Enter earliest start (mm/dd/yyyy)"? NOTE: you _must_ include
     the quotes and the question mark.
     
     7. Add a row
     And/Or = And
     Field Name = Start
     Test = is less than
     Values = "Enter latest start (mm/dd/yyyy)"? NOTE: you _must_ include the
     quotes and the question mark.
     
     This filter will pick up tasks with the start date in the specified
     range. The test for Actual Work may not be necessary, but I've included
     it anyway.
     
     Click on OK and Close to exit from preparing the filter.
     
     8. View | Resource Usage and make certain the right hand side of the
     display is showing Actual Work. In the Formatting tool bar, select the
     filter you just created to demonstrate that it works and to show the items
     that will be selected.
     
     9. Click on View | Reports | Assignments | Who Does What When and click
     on the Edit button.
     
     10. On the definition tab, change the filter to the one you just created.
     11. On the sort tab, change the sequence to Name ascending.
     
     JLB, PMP
     
     
     
     On Thu, 4 Mar 2004 01:16:08 -0800, Arun
     <anonymous@discussions.microsoft.com> wrote:
     
> Hi,
>> is there any way that i can show only the tasks which have actuall
> booked for the date range that i specify.
> Now when i take the above said report...i can see the list of tasks
> assigned to the resource & the actual work put against each task on day
> basis is shown.
>> Since the task list is so huge i see all the task irrespective of
> actuals booked or not. I want to restrict this report to display only
> the task which have actuals booked.
>> can anyone suggest me in this regards??
>> cheers
     
     
     
     --