Report Builder: Include Only Top Level Gantt Chart Rows
I'd like to design a report of overdue projects in my Gantt chart. I can easily design a report showing all incomplete, over due tasks. But what if I only want the top level items on the report ... those that are not indented?
Using this forum, I read an answer to another question that prompted me to add a new column called "Top Level", in which I put an "x". So, how do I specify that the report should only output rows with "x" in "Top Level"?
I tried sorting, but that's not limited the report to Top Level records, only sorting all tasks.
Here's what's in the Report Builder:
- Where: My sheet
- Who: Blank
- What: % Complete is < 1
- When: Finish is in the future.