Custom Report

Tamana, 

You should be able to do this easily by creating a Custom Report by Project (Show Results From...). The fields you are looking for are as follows...

1. Project Name - <Project>.Name

2. Project Status - <Project>.Status (Based on doc, this seems like a custom field)

3. % Complete -  <Project>.%Complete

4. Planned effort - <Project>.Work (Work is Planned work for the Project)

5. Actual effort - <Project>.Actual Effort

6. Target - <Project>.Due Date

Then, you will want to sort as desired and filter by <Project>.Status to specify DEVELOPMENT.

Sincerely, 

Boris

Hi Boris, 

To be more precise, i want to show the Actual hours of Development task only of the project on the report and not the actual hours spent on entire project (which is what we get on the report using above fields).Meaning, we use SDLC template for the projects. Development is one of the Milestones. We want to pull the Actual hours (data) of Development (Milestone) only through that report which i mentioned earlier.

please suggest.

thanks,

Tamana, 

Then instead of creating it by Project, you will need to use by Work Item and then select the above fields but they will not start with <Project>, they will begin with <Work Item>. Try this...

1. Project Name - <Work Item>.Project

2. Project Status - <Work Item>.Status  -  (Based on doc, this seems like a custom field)

3. % Complete -  <Work Item>.% Complete

4. Planned effort - <Work Item>.Work (Work is Planned work for the Project)

5. Actual effort - <Work Item>.Actual Effort

6. Target - <Work Item>.Due Date

Note - I also suggest adding <Work Item>.Item Type which will tell you if the row is a Project, Milestone or Task. 

Let me know if this gives you what you need.

Sincerely, 

Boris