Forum Discussion
Microsoft Project - Using Filters with Report Tables
Just try this in the report:
Filter: Apply filter to Text1 (in the filter definition for Permits (Active), the checkbox "show related summary rows" has no effect on the report)
Group By: Apply group to Text1 (in the group definition, the checkbox "show summary tasks" is effective on the report, so you MUST select it)
Outline Level: All Subtasks
[ ] Show Hierarchy (not selected here in the report and not selected in the group definition)Just in case, make sure the task view has no filter, group or outline level set.
I guess this is the only way to see both the summary tasks with permit and the subtasks with permit on the same table of the report. But let's wait for John's response as he always comes up with a better solution.
Just try this in the report:
Filter: Apply filter to Text1 (in the filter definition for Permits (Active), the checkbox "show related summary rows" has no effect on the report)
Group By: Apply group to Text1 (in the group definition, the checkbox "show summary tasks" is effective on the report, so you MUST select it)
Outline Level: All Subtasks
[ ] Show Hierarchy (not selected here in the report and not selected in the group definition)
Just in case, make sure the task view has no filter, group or outline level set.
I guess this is the only way to see both the summary tasks with permit and the subtasks with permit on the same table of the report. But let's wait for John's response as he always comes up with a better solution.
No, I can't come up with a better solution than Ismet provided.
In my view there is a glitch in applying the filter to the report. It should respond to the basic filter elements (i.e. Text1=permits and Active=yes, including summary lines that meet the criteria). I suggest you submit a request through the feedback portal.
John