#1
|
|||
|
|||
Filter out completed tasks in a report
I am playing around with a simple report to create a report for a gentleman within the company who really loves his todo-lists...
I have created a simple table where I show - Project - Name (of task) - StartDate - EndDate - Resources allocated - Duration This table is then filtered on the gentleman in question and this produces a nifty, simple todo The thing that puzzles me is that in this list I can see prior tasks, already completed and I can not find a way to add an additional filter, to set table to only show future dates. The other way would of course be to somhow exlude tasks marked as 100% complete, but this one eludes me too... Any takers? |
#2
|
|||
|
|||
Add the % complete field to the table and use the autofilters (drop down to the right of the field name) to filter out tasks where % complete is 100%.
Using the autofilter allows you to filter on multiple columns on the fly. |
#3
|
|||
|
|||
I am not sure if we are talking about the same view here.
In Gannt view I have the option to filter the column as you describe. When in Report view, I cannot see any filter option per table column? Not even in the field list. I forgot to mention that the gentleman in question also loves his todo-lists printed... |
#4
|
|||
|
|||
Ah, sorry. You can create a custom task filter where
Resource Names contain "gentlemans name" AND Percent complete does not equal 100 The filter can then apply the filter to the report. |
#5
|
|||
|
|||
Worked like a charm, the only thing that made me go hmmm, was the fact that you apparently cant edit a created filter from the report view.
|
#6
|
|||
|
|||
You are correct, the filters can be applied but not edited in the report view. Pop back to a task view and edit away.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to show the overdue, Late, Onschedule & Completed tasks using MSP 2010 | AK04 | Project | 2 | 01-10-2016 06:35 PM |
To Do List Report (Project 2007) Displays Completed Tasks | SusanK | Project | 5 | 04-23-2014 07:12 AM |
Change font colour when tasks are completed | meileetan | Project | 3 | 09-12-2012 07:09 AM |
updating not completed tasks or 0% tasks | ketanco | Project | 3 | 08-24-2012 05:59 AM |
Outlook completed tasks synced with Windows Mobile 6.5 | ghumdinger | Outlook | 0 | 07-03-2011 07:22 AM |