Creating a report on tasks for the current period in MS Project Pro

Contents:

1. Adding a custom column to highlight the tasks of the current period  in MS Project Pro
2. Adding a filter to highlight the tasks of the current period in MS Project Pro
3. Creating a report on tasks for the current period in MS Project Pro
4. Chat

Adding a custom column to highlight the tasks of the current period  in MS Project Pro

Create a custom column to create a report and a filter for highlighting outstanding tasks of the current period.

Steps to add a custom column to highlight the tasks of the current period  in MS Project Pro:

1. Click the "Project" item in the top menu.
2. Click the "Custom Fields" button in the "Properties" block.
3. Click the "Task" box in the "Field" block.
4. Select the "Flag" in the "Type:" field.
5. Select en empty field in the list.
6. Click the "Rename..." button.
7. Enter the field name in the "Rename Field" window. (For example "Current period")
8. Click the "Formula ..." button in the "Custom attributes" block.
9. Enter the formula: "IIf((Val(DatePart("yyyy";[Start])*100+DatePart("ww";[Start]))>Val(DatePart("yyyy";Now())*100+DatePart("ww";Now())));False;True)"
10. Click the "Use formula" box in the "Calculation for task and group summary rows" block.
11. Click the "Ok" buttom.

Adding a filter to highlight the tasks of the current period in MS Project Pro

Create a filter to highlight outstanding tasks of the current period. Filter out the non-summery tasks as well as the tasks of a specific responsible person.

Steps to add a filter to highlight the tasks of the current period in MS Project Pro:

1. Add the "Responsible" costum colum. (Read more "Assigning responsible persons to tasks in MS Project Pro")
2. Click "View" the item in the top menu.
3. Open the "Filter" field in the "Data" block.
4. Click the "More Filters ..." button.
5. Click the "New ..." button.
6. Enter the name in the "Name:" field. (For example "Current task ...").
7. Click the "Show in menu" box.
8. Select the "% Complete" in the "Field Name" column.
9. Set the "does not equal" in the "Test" field.
10. Set the "100%" in the "Value(s)" field.
11. Add a new row below.
12. Set a "And" in the "And/Or" field.
13. Select the "Current period" in the "Field Name" column. (Read more "Adding a custom column to highlight the tasks of the current period  in MS Project Pro")
14. Set the "equal" in the "Test" field.
15. Set the "Yes" in the "Value(s)" field.
16. Set a "And" in the "And/Or" field.
17. Select the "Summary" in the "Field Name" column.
18. Set the "equal" in the "Test" field.
19. Set the "No" in the "Value(s)" field.
20. Set a "And" in the "And/Or" field.
21. Select the "Responsible" in the "Field Name" column. (Read more "Assigning responsible persons to tasks in MS Project Pro")
22. Set the "equal" in the "Test" field.
23. Set the ""Responsible:"?" in the "Value(s)" field.
24. Click the "Ok" button.

Creating a report on tasks for the current period in MS Project Pro

Steps to add a table to a report on tasks for the current period in MS Project Pro:

1. Click the "Report" item in the top menu.
2. Create the report.
3. Click the "Report Design" item in the top menu.
4. Click the "Table" button in the "Insert" block.
5. Click the "Table Desigen" item in the top menu.
6. Click the "Table Date" button in the "Show/Hide" group.
7. Select the "Task" in the "Field List" block.
8. Click on the required fields in the "Select Field" box. Select fields: "Name", "Critical", "Start", "Finish", "Resource Names" and "Total Slack".
9. Choose the "Current task ..." in the "Filter" field.
10. Set the "All Subtasks" in the "Outline Level" field.
11. Set the "Start" in the "Sort by" field.
12. Customize the table layout in the report. (Read more "Customize the table in the report in MS Project Pro")