#Excel Services REST API in #SSRS report #ProjectServer 2010 #PS2010 #MSProject #SP2010 #SharePoint

Following on from my previous post that demonstrated embedding Excel Services objects in Word using the Excel Services REST API, this post demonstrates using the Excel Services REST API in SSRS reports. Once you have gone to the time and effort creating the charts in Excel services you don’t want to have to go to...

#ProjectServer 2010 reports in #MSWord using the #Excel Services REST API #PS2010 #SP2010

I have put together a quick example to show how easily and quickly a dynamic report can be created in Microsoft Word. You could easily create monthly reports for Project Sponsors, directors etc. In this example I have just created a simple Project Cost report to show the concept. The report can be seen below:...

#ProjectServer task level and resource level custom field values in PWA assignment views #PS2007 #PS2010 #MSProject

Quite frequently I see questions relating to new task level custom fields added to the My assignments view on the Tasks page or the Timesheet views don’t show the custom field values set against the tasks. Similarly, new resource level custom fields added to the Summary view on the Resource Assignments page don’t show the...

#ProjectServer 2010 Reminders web part displays new task assignments but the tasks page doesn’t show any tasks #PS2010 #MSProject

**** UPDATE - This issue is resolved in the Project Server 2010 October 2011 CU **** You will see this when the user has created a new project plan and assigned generic resources. As generic resource can’t own assignments the user who created the Project Plan will be the assignment owner as shown below: When...

#ProjectServer webcast on Deploying Project Server on #VMware with Shared Infrastructure #MSProject #PS2010 #PS2007 #EPM #SP2010 #SharePoint

One of my colleagues, Sacha Cohn, is presenting a webcast for best practices on Successfully Deploy Project Server on VMware with Shared Infrastructure, sign up below: https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032493923&Culture=en-US This webcast will highlight some of the challenges faced with deploying on a virtual environment and detail key areas that could impact performance.

#ProjectServer 2003 migration to Project Server 2007 issue #PS2003 #PS2007 #MSProject

I came across an issue today running the P12 migration tool and thought I would share the error and simple fix. The command prompt didn’t update for around an hour, the last entry mentioned about custom field name conflicts. Looking in the log file it was just repeating the following messages: Received serializer callback: 4...

Accessing custom fields that allow multiple values from look up tables in #ProjectServer via T-SQL #MSProject #PS2010 #PS2007

At recent query came up on the Project Server forum regarding accessing custom fields that allow multiple values in the PWA_Reporting database. This is quick post to show how this can be achieved. In this example I have a single value lookup custom field called ProjectStatus and a custom field that allows multiple values called...

#Project Server 2010 August 2011 Cumulative update #PS2010 #SP2010 #MSProject

The Office 2010 August 2011 Cumulative Updates are now available, please see the link below: http://support.microsoft.com/kb/2588842 Project Server 2010 August 2011 CU: http://support.microsoft.com/kb/2553047 Project 2010 August 2011 CU: http://support.microsoft.com/kb/2584056 As always, test these updates on a test environment before deploying to production. For more information, please see the following link: http://blogs.technet.com/b/projectadministration/archive/2011/09/01/microsoft-project-server-and-sharepoint-2007-and-2010-august-cu-2011-announcement.aspx