#ProjectServer 2010 Resource assignments display issue #PS2010 #SP2010 #PS2013 #SP2013September 20, 2012 at 7:44 pm | Posted in Functionality, Issue, Reporting, T-SQL | 1 Comment
Tags: Project 2010, Project Server 2010, PS2010
Recently I was reminded of a minor issue that I thought I would share with you. While working with a client for a recent migration from Project Server 2007 to Project Server 2010, a query was raised regarding material resources and the resource assignment view in PWA. Material resources show a work and remaining work value with an hours ‘h’ label in 2010, in 2007 this displayed the material resource label. This is only a display issue, the underlying data is still correct in the Reporting database, so your reports will be correct. An example in PWA 2010 can be seen below:
I have a material resource named ‘material resource’ (sorry about the poor names used on my test system, I should really use some imagination!), I have assigned this material resource to two tasks, one task has 10 units and the other has 5 units. As you can see from the screen shot above, this displays 10h and 5h rather than 10 material resource and 5 material resource as you would have seen in 2007. Example shown below for PWA 2007:
As mentioned the Reporting data is still correct, see the example SQL output below:
The assignment work column correctly shows 0 and the assignment material work shows 10 and 5.
This is also an issue with the Project Server 2013 preview.
Just a minor display issue that I thought I would share in case anyone else came across this