Timesheet reporting

[MswT]

Hi all,

Does anyone have the "definitive" report set (and how to generate them) for
timesheet reporting.

i.e. Timesheet registered hours within a given time slot grouped..

by Project

by Person

I have Data Analysis set up and the Reporting Services package installed.

Matt

 

[Marc Soester [MVP]]

hi matt,

When you say "definite" reports, what exactly do you mean?

when you have Analysis Server installed and your cubes are build, you can
create your own reports. All you need to do is create new views for the Data
Analyser.

Same with the reporting pack. If you have them installed and they are
working, you already have timesheet reports.

Hope this helps

 

[MswT]

I have built some views on the MSP_Project_Timesheet cube but this seems to
show hours reported into projects thru My tasks rather than those hours
entered into the timesheet page.

I wanted a report that showed hours added to the timesheets (project and
admin time).

Any ideas?

Ideally a report that shows hours entered for each resource across a date
range listed by task (allowing summary for the project).

 

[Marc Soester [MVP]]

Hi Matt,

you should get your information out of the timesheet cubes. Alternetafly you
could use either reporting services or the report builder to create your
reports by accessing the reporting DB of Project Server. The information you
are after is certainly in the Reporting DB
Hope this helps
--
Marc Soester [MVP]
National Manager: EPM
http://marcsoester.blogspot.com