Extracting Timephased data using sp_spactualsbyweek

B

bill_murphy

I have been trying to use the above stored proceedure provided by MS
and no data is been displayed. I had a look and the issue is there are
no rows in the MSP_WEB_WORK table with the worktype 1 which I assume is
Actual. However when I look at the projects using PWA and the "Tasks
Work" view I can see Actual time.
Can any one suggest what's going on? I have re-published All
information with no errors displayed
 
P

Peter Theill

I have been trying to use the above stored proceedure provided by MS
and no data is been displayed. I had a look and the issue is there are
no rows in the MSP_WEB_WORK table with the worktype 1 which I assume is
Actual. However when I look at the projects using PWA and the "Tasks
Work" view I can see Actual time.
Click to expand...

I think to remember you have to check the "Expand timephased data in the
database" checkbox under "Options | Save" in your Project client.
 
Top