Microsoft KB Archive/67731

Project: Not All Tasks Filtered If Resource Name Is Criterion

PSS ID Number: Q67731 Article last modified on 03-15-1995

1.00 3.00 3.00a 4.00| 1.10

WINDOWS | MACINTOSH

= SYMPTOMS =

In Microsoft Project, when you use Resource Name as the one of the filter criteria, Microsoft Project may not filter all the tasks in a Task Sheet.

= CAUSE =

This problem occurs because resource names in a table are truncated after a certain number of characters (this number varies depending on your version of Microsoft Project).

For Microsoft The Resource Name is truncated Project version after this number of characters ————————————————-

4.0 252 3.x 252 1.x 77

Any resources assigned after the truncation point are not filtered.

= WORKAROUND =

To work around this problem, do either of the following:

  Filter tasks using Resource Initials instead of Resource Name. -or-   Use shorter resource names. 

= MORE INFORMATION =

Steps to Reproduce Problem in Project 4.0
  Create a new project.   From the View menu, choose Resource Sheet. Create five resources with names containing 20 characters.   From the View menu, choose Gantt Chart. Enter two new tasks.   Assign resource 3, 4, and 5 to task 1.   Assign resource 1, 2, 3, 4, and 5 to task 2. </li>  From the Tools menu, choose Filtered For, and then choose More Filters. Choose the New button. </li>  In the Filter Definition dialog box, enter the following criteria for the new filter: Field Name Test Value(s) ——————————————————— Name Contains “Enter Resource Name”? </li></ol>

8 Choose OK, then choose Apply.

<ol start="9" style="list-style-type: decimal;"> When the filter displays a dialog box that prompts you for the resource name, type the name for resource 5.</li></ol>

Note that only task 1 is displayed even though resource 5 is assigned to BOTH tasks.

KBCategory: kbother KBSubcategory:

= Additional reference words: 1.00 1.10 3.00 3.00a 4.00 =

Copyright Microsoft Corporation 1995.