New custom view/report in Project server 2007

A

Arun

Hi,
I am using project server 2007. I am in need to create a weekly report
with following fields

ProjectName,TimeSheetStartDate,ResourceName,Tasks,Hoursworkedin this
week,TotalWork(in hrs),Remaining work(in hrs), TaskType

Is it possible get the report from project web access. If possible how can I
generate that?

Thanks,
Arun
 
J

Jay Carter

This might be possible using the MSP_Project_Timesheet cube in the Data
Analysis area of 2007. The cube fields list has some of the fields you need.
Unfortunately, MSP_Project_Timesheet doesn't work (at least with my testing).

I built a similar report using the Timesheet cube. I put Timesheet Period
and Timesheet Resource List on one axis (you could easily add Timesheet
Project List) to that, and month and day on the other. I use the Actual Work
Billable measure.

What you don't have are the total work and the remaining work. This is
consistent with the Timesheet itself, which does not show those fields, only
the planned work for the specific days of the timesheet period. (This is
Planned Work in the cube.)

Is Task Type the built-in field, which shows Fixed Duration, Fixed Work, and
Fixed Units? That's not in the cube. You would have to code a customization
to get that. If by Task Type you mean some custom field, you can add those as
long as they have lookup tables. Use the Cube Configuration page of Server
Settings in PWA.

I hope this helps.
 
D

Dale Howard [MVP]

Arun --

I believe you need to extract this report from the Reporting database using
a database reporting tool such as SQL Reporting Services or Crystal Reports.
Hope this helps.
 
C

Colin

Jay - What do you mean MSP_Project_Timesheet doesn't work because I have
experienced some problems getting actuals out of that cube as well. What
problems have you had with that cube?

Colin
 
J

Jay Carter

I can see Actual Work and Work values if that's all I show in the view, but
when I drag in Timesheet Periods, the measures disappear. In fact, if I drag
in any of the Timesheet dimensions, the measures go away.

I have created timesheets and filled out timesheets and approved timesheets
- the whole lifecycle practically. While it's possible that there's some step
I am missing to get the MSP_Project_Timesheet to populate properly, I really
think there is a bug. The other timesheet cubes (Timesheet and EPM Timesheet)
seem to work fine.
 
T

TGG

Arun,

I've published a SQL Server Reporting Services (SSRS) Report Pack for
Project 2007 on the team blog. There are two timesheet related reports which
may meet your needs.

Go to http://blogs.msdn.com/project to find them. More extensive
documentation around this report pack will be release in the coming weeks.

Thanks!
--Treb

Treb Gatte
Program Manager II
Microsoft Office Project Server
 
Top