reporting: Can I emulate the Tasks display?

[shodgman]

G'day there,
I would like to generate a report that will show basically the same display as what is shown in the Tasks Tab, well this version of it.

For a given (parameter) workspace:
I want to have report breaks (headings/ subheadings) by Milestone then Tasks and the subtasks nested in the display
I want to restrict by "Status" (pending, complete, etc)
e.g something like:

My Development Workspace

Milestone Name

Task to create a list
      This is the first item in the list task
      Second task
Next task with no subtasks
third task has su and sub sub tasks
    First subtask
          First sub sub task
         another sub sub task
    second sub task
......

Can anyone suggest a way of getting this result please?
Thanks,
---
Steve Hodgman

[supadoctor]

Also interesting in the same thing... 

[franponce87]

Hi Steve, welcome to Feng Office Forums!
For the time being you cannot make reports which would be displayed exactly the same way as in the Tasks tab, but you may be able to get something similar in the Tasks Custom Reports (located at the 'Reporting' tab).

Either way, in order to know if a task or milestone status, you may use the following fields: completed_on and completed_by.. if completed_by is '0' it means it still is pending. The same goes with the completed_on field.

Best regards,
Francisco

[shodgman]

Francisco,
Thanks for the reply.  The Custom Reports screen does nto allow me to do what you have specified.
If I choose a condition on "Completed By" it forces me to choose a user.
Similiarly, for "Completed On", it forces me to choose a date.

How can I create a custom report that shows the "pending" tasks under a Milestone?
---
Steve Hodgman

[franponce87]

I meant once you see the report result..

Best regards,
Francisco

[supadoctor]

I resolve this problems with custom select to FO DB from Excel (via ODBC for MySQL).