Strange Behavior: Creating Excel Report

• Question

• 

  

  0

  Sign in to vote

  Dear All,

  I have A very Strange Behavior i beleive this how i must called and if i am wrong please someone should correct me and guide me :) 

  Anyway, i am using Project Server 2010 SP1, everything is up and running without any problems.

  I'm trying to create an Excel Reports with the following query:

  SELECT     dbo.MSP_EpmProject_UserView.ProjectName AS [Project Name], dbo.MSP_EpmTask_UserView.TaskName AS [Summary Task], 
                        dbo.MSP_EpmTask_UserView.TaskActualWork AS [Task Actual Work], dbo.MSP_EpmTask_UserView.TaskPercentCompleted AS [Task Percent Completed]
  FROM         dbo.MSP_EpmProject_UserView INNER JOIN
                        dbo.MSP_EpmTask_UserView ON dbo.MSP_EpmProject_UserView.ProjectUID = dbo.MSP_EpmTask_UserView.ProjectUID
  WHERE     (dbo.MSP_EpmTask_UserView.TaskOutlineLevel = 1)
  ORDER BY [Project Name], dbo.MSP_EpmTask_UserView.TaskIndex, [Summary Task]

  The Report which i am trying to create is a very simple report as you can see, all i want is to just show the % complete and the Actual Work for The Summary Task Only with a filtration for the Project Name.

  I created the report in one instance of Project Server which doesn't have Time Reporting Periods Configured on the Server Settings, and the Report Result is working perfectly as i was expecting.

  Now, i shift the report to anther instance which have the Time Reporting Periods configured, the result now is very strange which is showing me (Timesheet Administrative Work Items) As A Project Name And (Week1, Week2, etc...) As An Summary Task.

  I hope if i can get an answer regarding this and if i already explain it as it should.

  ---

  Best Regards, Khaled

  • Changed type Barbara HenhaplMVP Monday, August 13, 2012 9:55 AM It's a question, no discussion

  Monday, August 13, 2012 6:17 AM