Reporting services: info about "Import Timesheet"?

[jpa]

Hi,
(PS2007, SP1 + PIU)
We use Timesheet to enter time spent on tasks including "remaining work".
Once Timesheet ahas been submitted the team member has to go within "My task"
to do
1) "Import Timesheet" so update "actual work" of the tasks
2) "Submit All" so that Project Manager (PM) can be alerted of task updates.

Question is: I am not the Project Manager but I want to audit overall Task
update process, is there any means to know about "Import Timesheet" status
for a given timesheet?
I was wondering whether this information could be retrieved from any table
in database thru Reporting Services interface...

Thanks for your suggestions
jpa

 

[Ray McCoppin]

You might look at the following links. These should give you a good start
for that you wnat.

http://blogs.msdn.com/chrisfie/arch...nded-report-pack-from-project-conference.aspx

http://blogs.msdn.com/chrisfie/arch...project-server-reporting-database-schema.aspx


--
Ray McCoppin

http://www.randsmanagement.com
SRS gantt charts
Project Server 2007 Reports

 

[jpa]

Ray, Many thanks for your inputs

Actually I already use information issued from your 2 pointers but
unfortunately I didn't find yet info I am looking for...

Any additional help is welcome
thanks in advance
jpa

 

[Jonathan Sofer [MVP]]

I don't believe this data is available in the database for retrieval.

As a side note, I noticed you are using the "Remaining Work" column in "My
Timesheets" and I wanted to warn you that unlike the rest of the timesheet
hours, changes to "Remaining Work" are instantaniously updated in "My
Tasks".

The reason this is bad is because when you import your timesheet it will
reduce "Remainig Work" again so you are actually doing a double update to
remaining work which is way wrong! Check it out and let me know if you are
seeing the same results.

Jonathan Sofer