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

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article has been archived. It is offered "as is" and will no longer be updated.
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

  1. On the Project menu, point to Filtered for, and then click More Filters. For Project 2010, go to the View tab, click the Filter dropdown, and select More Filters.
  2. Click New.
  3. In the Name box, type Work Resource Assignments.
  4. Enter the following filter information:
       And/Or     Field Name         Test               Value(s)   ---------------------------------------------------------              Resource Type      does not equal     Material					
  5. Click OK. For Project 2010, click Save.
  6. Click Close.

Modify the Report to Use the Filter

  1. On the View menu, click Reports. For Project 2010, go to the Project tab and click the Reports button.
  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.
  4. 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.
  5. Click OK.
  6. 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

  1. On the Project menu, point to Filtered for, and then click More Filters. For Project 2010, go to the View tab, click the Filter dropdown, and select More Filters.
  2. Click New.
  3. In the Name box, type Material Resource Assignments.
  4. Enter the following filter information:
       And/Or     Field Name         Test               Value(s)   ---------------------------------------------------------              Resource Type      does not equal     Work					
  5. Click OK. For Project 2010, click Save.
  6. Click Close.

Modify the Report to Use the Filter

  1. On the View menu, click Reports. For Project 2010, go to the Project tab and click the Reports button.
  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.
  4. 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.
  5. Click OK.
  6. Click either Preview or Print.
Properties

Article ID: 242635 - Last Review: 01/11/2015 03:07:10 - Revision: 5.0

  • 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 2000 Standard Edition
  • Microsoft Project Professional 2010
  • Microsoft Project Standard 2010
  • kbnosurvey kbarchive kbhowto KB242635
Feedback