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

Article translations Article translations
Article ID: 242635 - View products that this article applies to.
This article was previously published under Q242635
Expand all | Collapse all

On This Page

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: September 18, 2011 - Revision: 4.0
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 2000 Standard Edition
  • Microsoft Project Professional 2010
  • Microsoft Project Standard 2010
Keywords: 
kbhowto KB242635

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com