Answered by:
Custom Report on Resource Working Time, Nonworking Time, Vacations and Sick time

Question
-
Hi everybody
I want to generate a custom report about working time of resources. my report that is on a approved time period have the following fields
Resource Name//No. of Working Days//No. of Non. Working Days// No. of Vacations//No. of Sick Times//
I did not found any template on BI center of PWA creating such a custom report.
Can anybody help me creating this report??
Regards
--mhhe
Monday, June 27, 2011 12:09 PM
Answers
-
mhhe,
You should be able to use the Timesheet Data ODC/Template to start with, and the put in formulas in your Excel to build this report.
Obviously, if you know SSRS, it is much easier to build this custom report.
Prasanna Adavi, PMP, MCTS http://thinkepm.blogspot.com- Proposed as answer by Prasanna AdaviMVP Friday, July 22, 2011 10:29 AM
- Marked as answer by Christophe FiessingerMicrosoft employee Thursday, December 22, 2011 6:30 AM
Monday, June 27, 2011 3:13 PM -
Shadi,
Yes, you can use Report Builder, as well.
Prasanna Adavi, PMP, MCTS http://thinkepm.blogspot.com- Marked as answer by Christophe FiessingerMicrosoft employee Thursday, December 22, 2011 6:30 AM
Thursday, July 21, 2011 3:34 PM
All replies
-
hi,
You have to create this report using SSRS through reporting database.
Nur MondalMonday, June 27, 2011 12:57 PM -
Hi there,
You would need to create a data connection from within Excel to the Timephased Cube of PWA to do that. Have a look at http://blogs.technet.com/b/epmcontent/archive/2011/06/24/project-server-2010-reporting-with-excel-services-amp-creating-dashboards-white-papers.aspx
Andre
Monday, June 27, 2011 1:07 PM -
mhhe,
You should be able to use the Timesheet Data ODC/Template to start with, and the put in formulas in your Excel to build this report.
Obviously, if you know SSRS, it is much easier to build this custom report.
Prasanna Adavi, PMP, MCTS http://thinkepm.blogspot.com- Proposed as answer by Prasanna AdaviMVP Friday, July 22, 2011 10:29 AM
- Marked as answer by Christophe FiessingerMicrosoft employee Thursday, December 22, 2011 6:30 AM
Monday, June 27, 2011 3:13 PM -
hi
Why don't you use Report Builder?
I am new in this and try to use Report Builder.I want to know is it possible to use Report Builder?
Wednesday, July 20, 2011 5:33 AM -
Shadi,
Yes, you can use Report Builder, as well.
Prasanna Adavi, PMP, MCTS http://thinkepm.blogspot.com- Marked as answer by Christophe FiessingerMicrosoft employee Thursday, December 22, 2011 6:30 AM
Thursday, July 21, 2011 3:34 PM