Work Versus Effort Audit Report

[greg]

Hello,
I am trying to get this sample report to work with Project server 2007.
I have loaded the report into SQL Server Reporting Services.
And looking at the directions:
http://msdn2.microsoft.com/en-us/library/bb428821.aspx
I see there are some items that have to be created. But it does not really
say hot to create.
So for example it says:
The Project_Data_Source query uses the following tables in the RDB:
MSP_EpmResource
MSP_Timesheet
MSP_TimesheetActual
MSP_TimesheetPeriod
MSP_TimesheetResource
MSP_TimesheetPeriodStatus
MSP_TimesheetStatus

So I am assuming I need to create these.

Also, it talks about running Query for the Timesheet Periods in query
designer.
When I do I also get an error:
Msg 208, Level 16, State 1, Line 1
Invalid object name 'MSP_TimesheetPeriod'.

pointing at code like:
.......RTRIM(CAST(MSP_TimesheetPeriod.PeriodName AS char)) +........


Can someone help on what to create?
thanks for help

 

[Jonathan Sofer]

You might want to also post this to the microsoft.public.project.developer
group.

Have you validated that your datasources are connecting successfully to your
project server databases?

Jonathan