Biiling report - PS2007

[ss028955]

I have a reporting requirement for Project server 2007 .I tried using cube
but not all fields are available and tried Project centre Actual Hrs and
Actual cost show always 0.
Please help.

Requirements are:

Timesheet Billing Report with below columns:

System (Custom Field), Application name (Custom field) , Project Name,
Department code (Custom Field), GL_Code (Custom Field), Project_Code
(Custom Field), Actual Hrs spent, Actual Amount spent.


Billing Report for Closed Project with below columns:

System (Custom Field), Application name (Custom field) , Project Name,
Department code (Custom Field), GL_Code (Custom Field), Project_Code
(Custom Field), Actual Hours, Actual Amount, Estimated Hrs, Estimated Amount,
Variance


Regards
SS028955

 

[Rod Gill]

Hi,

I would create a SQL Server View in the Reporting Database showing the data
I want. I would then either read that into Excel using MS Query or write
Excel VBA code to read and format it. Alternatively use any reporting tool
you have available on that View.

Note that the MSP_Project_userview View in the Reporting table will
automatically have all your custom fields added as columns (as do all other
Views ending in _userview). Sum totals for the project's tasks to get the
Actual Hrs and $ spent.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[ss028955]

Hi Rod,

Did you mean there is a out of box view called MSP_Project_userview in
Reporting database?
Actually I am unable to locate that view under Reporting database.

Regards
Ss028955

 

[ss028955]

thanks Rod,

I found the view called MSP_EpmProject_Userview, Which does have all the
fields but the actual works and actual costs value are incorrect. Most of the
project has 0 actuals where as if I go to My timesheet, I can seen I have
logged billable time against many projects.

Any idea?

Regards
ss028955

 

[Rod Gill]

Remember that Timesheets do not update Tasks. If My Tasks have not imported
Timesheet data and been submitted, then there will be a discrepancy. You can
sum Timesheet totals in the Reporting db instead if you prefer, but from
memory you need to use the Timesheet tables as the timesheet Views aren't
useful. You should not touch any of the Views with Cube in their name. If My
Tasks have been submitted, then have the relevant projects been opened in
Project Professional recently and published?

That is the View, I didn't remember its name correctly!

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[ss028955]

I have Imported timesheet and submited. and Non of the projects has been
checked out either. I am totaly lost. I have no idea which table to look at.

I think Timesheet functionality in Project Server 2007 is shocking.

Thanks
ss028955

 

[Rod Gill]

The timesheet side seems OK, but My Tasks is nearly unusable in my
experience. Have you upgraded to SP1?

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[ss028955]

Yap.

I figured out how to get actul balance. May be I misunderstood you before.

To be able to see Actual time , We need to import the timesheets to tasks
then save and publish. then open the project then publish it.

This is crapy way of doing it, but it works.

Regards
ss028955