Microsoft KB Archive/242635

= How to print crosstab report with either work or material resources in Project =

Article ID: 242635

Article Last Modified on 1/25/2007

-

APPLIES TO


 * Microsoft Office Project Professional 2007
 * Microsoft Office Project Standard 2007
 * Microsoft Office Project Professional 2003
 * Microsoft Office Project Standard 2003
 * Microsoft Project 2002 Professional Edition
 * Microsoft Project 2002 Standard Edition
 * Microsoft Project 2000 Standard Edition

-



This article was previously published under Q242635



SUMMARY
In Microsoft Project, in crosstab reports with task details, when you include resource assignment details, both work resource assignments and material resource assignments are displayed. This article describes how to print a crosstab report with task detail that includes only one type of resource assignment, either work resource assignments or material resource assignments.



MORE INFORMATION
To display only one type of resource assignment in a crosstab report with task details, you must create a task filter and apply it in the report. To do this, use the appropriate method below for the type of resources you want to display.

Method 1: Display Work Resources and Not Material Resources
To display work resources and not display material resources, follow these steps:

Create the Filter
 On the Project menu, point to Filtered for, and then click More Filters. Click New. In the Name box, type Work Resource Assignments .  Enter the following filter information:   And/Or     Field Name         Test               Value(s) -             Resource Type      does not equal     Material  Click OK. Click Close.</li></ol>

Modify the Report to Use the Filter

 * 1) On the View menu, click Reports.
 * 2) Click Custom, and then click Select.
 * 3) Click the crosstab report that you want to edit, and then click Edit.

NOTE: Optionally, you can create a new crosstab report.
 * 1) In the Filter list, click the Work Resource Assignments filter that you created in the preceding steps.

NOTE: In crosstab reports, to show resource assignments, you must select the And resource assignments check box.
 * 1) Click OK.
 * 2) Click either Preview or Print.

Method 2: Display Material Resources and Not Work Resources
To display material resources and not display work resources, follow these steps:

Create the Filter
<ol> On the Project menu, point to Filtered for, and then click More Filters.</li> Click New.</li> In the Name box, type Material Resource Assignments .</li>  Enter the following filter information: <pre class="fixed_text">  And/Or     Field Name         Test               Value(s) -             Resource Type      does not equal     Work </li> Click OK.</li> Click Close.</li></ol>

Modify the Report to Use the Filter

 * 1) On the View menu, click Reports.
 * 2) Click Custom, and then click Select.
 * 3) Click the crosstab report that you want to edit, and then click Edit.

NOTE: Optionally, you can create a new crosstab report.
 * 1) In the Filter list, click the Material Resource Assignments filter that you created in the preceding steps.

NOTE: In crosstab reports, to show resource assignments, you must select the And resource assignments check box.
 * 1) Click OK.
 * 2) Click either Preview or Print.

Keywords: kbhowto KB242635

-

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

© Microsoft Corporation. All rights reserved.