Microsoft KB Archive/97850

= PRJ: Filter for Summary and Related Detail Tasks =

Article ID: 97850

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Project 98 Standard Edition
 * Microsoft Project 4.1 Standard Edition
 * Microsoft Project 4.1a
 * Microsoft Project 3.0 Standard Edition
 * Microsoft Project 3.0a
 * Microsoft Project 4.0 Standard Edition
 * Microsoft Project 3.0 for Macintosh
 * Microsoft Project 4.0 for Macintosh

-



This article was previously published under Q97850



SUMMARY
In Microsoft Project, you cannot create a filter that will automatically display the related subordinate tasks of summary tasks that meet the filter criteria. However, you can create a custom macro to achieve a result similar to what this type of filter would produce.



MORE INFORMATION
Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements. As an example to use a macro in conjunction with a custom filter to filter all summary tasks that are currently in progress and then display all the subordinate tasks associated with them:

Microsoft Project 98
 On the Project menu, point to Filtered For, and then click More Filters. Click New.  In the Name box, type In-Progress Summaries. Set up the filter with the following information:       And/Or    Field Name       Test              Value(s) -                Summary          equals            Yes And      Actual Start     does not equal    NA       And       % Complete       is less than      100%  Click OK. Click Close. On the Tools menu, point to Macro, and then click Macros. In the Macro Name box, type In_Progress_Summary_Groups. Click Create.</li>  Type the macro exactly as it appears below: Sub In_Progress_Summary_Groups ViewApply Name:=&quot;Gantt Chart&quot; FilterApply Name:=&quot;In-Progress Summaries&quot; SelectColumn OutlineHideSubtasks OutlineShowAllTasks End Sub </li> On the File menu, click Close and Return to Microsoft Project.</li> On the Tools menu, point to Macro, and then click Macros.</li> Click &quot;In_Progress_Summary_Groups&quot; and then click Run.</li></ol>

NOTE: Any task filter may be substituted for the &quot;In-Progress Summaries&quot; filter.

Running the above macro will automatically display the Gantt Chart view, filter Summary tasks that are in progress, and then expand all the subordinate tasks for the Summary tasks that are displayed.

If you do not want to create a macro, you can use the following alternative:
 * 1) Apply the task filter.
 * 2) Click a column in the table.
 * 3) On the Project menu, point to Outline, and then click Hide Subtasks.

In Microsoft Project for Windows, you can also press ALT+SHIFT+HYPHEN.
 * 1) On the Project menu, point to Outline, and then click Show All Subtasks.

In Microsoft Project for Windows, you can also press ALT+SHIFT+* (asterisk on the numeric keypad).

Microsoft Project 4.x
<ol> On the Tools menu, point to Filtered For, and then click More Filters.</li> Click New.</li>  In the Name box, type In-Progress Summaries. Set up the filter with the following information: <pre class="fixed_text">     Field Name       Test            Value(s)    And/Or ---     Summary          Equals          Yes         And Actual Start    Not Equals      NA          And % Complete      Less            100% </li> Click OK. Click Close.</li> On the Tools menu, click Macros.</li> Click New</li> In the Macro name box, type In_Progress_Summary_Groups. Click OK.</li>  Type the macro exactly as it appears below: Sub In_Progress_Summary_Groups ViewApply Name:=&quot;Gantt Chart&quot; FilterApply Name:=&quot;In-Progress Summaries&quot; SelectColumn OutlineHideSubtasks OutlineShowAllTasks End Sub </li> On the Tools menu, click Macros.</li> Click &quot;In_Progress_Summary_Groups&quot; and then click Run.</li></ol>

NOTE: Any task filter may be substituted for the &quot;In-Progress Summaries&quot; filter.

Running the above macro will automatically display the Gantt Chart view, filter Summary tasks that are in progress, and then expand all the subordinate tasks for the Summary tasks that are displayed.

If you do not want to create a macro, you can use the following alternative:
 * 1) Apply the task filter.
 * 2) Click a column in the table.
 * 3) On the Project menu, point to Outlining, and then click Hide Subtasks.

In Microsoft Project for Windows, you can also press ALT+SHIFT+HYPHEN.
 * 1) On the Tools menu, point to Outlining, and then click Show All Tasks.

In Microsoft Project for Windows, you can also press ALT+SHIFT+* (asterisk on the numeric keypad).

In Microsoft Project for the Macintosh, you can press COMMAND+OPTION+* (asterisk on the numeric keypad).

Microsoft Project 3.0
<ol> On the Filter menu, click Define Filters.</li> Click New.</li> <li> In the Name box, type In-Progress Summaries. Set up the filter with the following definition: <pre class="fixed_text">     Field Name       Test          Value(s)  Op      -

Summary         Equals        Yes       And Actual Start    Not Equals    NA        And % Complete      Less          100 </li> <li>Click OK. Click Close.</li> <li>On the Macro menu, clcik Define Macros.</li> <li>In the Macro Name box, type In-Progress Summary Groups .</li> <li> Type the macro exactly as it appears below: View .Name=[Gantt Chart] Filter .Name=[In-Progress Summaries] SelectColumn OutlineCollapse OutlineExpandAll </li> <li>Click OK.</li> <li>To run the macro, click Set.</li></ol>

NOTE: Any task filter may be substituted for the &quot;In-Progress Summaries&quot; filter.

Running the above macro will automatically display the Gantt Chart view, filter Summary tasks that are in progress, and then expand all the subordinate tasks for the Summary tasks that are displayed.

If you do not want to create a macro, you can use the following alternative:
 * 1) Apply the task filter.
 * 2) Select a column in the table.
 * 3) Click Collapse.

In Microsoft Project for Windows, you can also press ALT+SHIFT+- (minus sign on the numeric keypad, NUM LOCK off).

In Microsoft Project for Macintosh, you can press COMMAND+OPTIONS+- (minus sign on the numeric keypad, NUM LOCK off).
 * 1) Click Expand All.

In Microsoft Project for Windows, you can also press ALT+SHIFT+* (asterisk on the numeric keypad).

In Microsoft Project for Macintosh, you can press COMMAND+OPTION+* (asterisk on the numeric keypad).

Additional query words: 1.00 1.10 3.00a

Keywords: kbdtacode kbhowto KB97850

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.