Tuesday, April 21, 2009

I want this report, right now!

Yes, most probably you had faced this situation while showing to your boss one of the great view that comes with Microsoft Project Professional 2007 or the views that you have customized.  If you did a great job in showing or customizing such a view then you will expect your boss to ask you to print it as report and send it to him/her, right now!

So the idea that I will illustrate in this post is summarized as the following

  • Customize your own table with the specific fields that your boss is looking for
  • Customize your own report to show this view/table as report
  • Make this report available for all projects

Step 1 : Customize your table

  1. Click on View => Table:  => and select More Tables

    image
  2. In the dialog below click on New

    image
  3. Enter the table information as per the image below

     image
  4. Click Ok to save your table, remember the table name “Track Summary Report”
  5. Click Apply to see your table

 

Step 2: Create Your Own Report

  1. On the menu bar, click on Report => Reports then click on Custom 

    image
  2. The dialog will list all the available reports, we will not use any of them, we will create our own, right? So click on New

    image
  3. Select Task, remember that we will design a report that will show the Tasks’ Tracking Information

    image
  4. Fill in the information for your report as per the dialog photo below

    image
  5. Click Ok after finish and click in Page Setup, usually you need to select the Landscape layout to be able to print as much information as you can in a single page. Don’t forget to set the paper size to A4

    image
  6. Click in Header and Footer tap and feel free to edit the look and feel of your report header and footer

    image
  7. Click OK, then “Preview” to preview your report

    image
  8. You are done, click Ok several time to go back to MS Project Pro 2007 main menu

Step Three: Make this report available to all projects

  1. On the main menu Click on Tools => Organizer

    image
  2. Select Report tab, select the “Tracking Summary Report” and then click << Copy to copy it to the Global template. So it will be available for the other projects

     image
  3. Done

Best Regards

Bilal Okour