How to generate a report showing sub-tasks (i.e., not just top level tasks)?

ty_roach
Tera Guru

‎03-15-2012 12:19 PM

How to generate a report showing sub-tasks (i.e., not just top level tasks)?

0 Helpfuls
  • 1,813 Views
6 REPLIES 6

kvillalobos
Giga Contributor
In response to ty_roach

‎02-17-2015 02:22 PM

I was trying to do the same thing and the solution I came up was to create a new database view which joined the pm_project and planned_task tables.



This was the only way in which I was able to get a full report with tasks and sub-tasks.



Hope it helps.


Screen Shot 2015-02-17 at 2.51.55 PM.png


Preview file
78 KB
0 Helpfuls

michaeljhiemstr
Giga Contributor
In response to kvillalobos

‎11-02-2015 02:34 PM

HI Kimberly,



Can you provide the details for how you joined the 2 tables? Specifically the where clause.



Thanks


0 Helpfuls