Error in MS Project: ‘The value you entered does not exist in the lookup table of this code. All values must be predefined in the code lookup table. Contact your server administrator to get new values

Posted By Posted by: EPM Partners on June 29, 2011

  The following error can appear in MS Project. In my case it was when I was attempting to insert sub projects into a Master Schedule. It may also appear in regards to modifying resource custom fields such as the RBS. Cause: It seems that MS Project is unable to handle custom lookup fields that

Read More


Blog Posted In 

Portfolio Management reports white papers

Posted By Posted by: EPM Partners on June 27, 2011

A number of Microsoft bloggers have recently announced some great new content for Project Server reporting and I thought that it is well worth repeating here.   Copied from Christophe’s Blog: I’m thrilled to announce the release of the following two white papers which provide step by step guidance on surfacing key Project Portfolio Management

Read More


Blog Posted In Blog Posted In: Project Server, Reporting
Blog Posted In 

How security permissions work in Project Server

Posted By Posted by: Dan Stopher on June 22, 2011

Project Server (both 2010 and 2007) have a quite sophisticated security model, in order to control security on portfolios, programmes, projects, reports, resources, etc. and we get a lot of our clients asking about how it works and what are the implications on changes on it.   Well Microsoft has posted a nice series of

Read More


Blog Posted In Blog Posted In: Project Server
Blog Posted In Comments Off on How security permissions work in Project Server

Removing Unwanted HTML Contents from SQL Server Reporting Services (SRS) Reports

Posted By Posted by: EPM Partners on June 20, 2011

When using SRS to deliver reports derived from data entered through multiline text fields, SRS frequently returns non alphabetic characters like those returned below: The following VB function removes unwanted HTML content from data retrieved from the Project Server Reporting database that is managed originally within a multiple-Line field on a Project Detail Page (PDP).\

Read More


Blog Posted In Blog Posted In: Reporting
Blog Posted In Comments Off on Removing Unwanted HTML Contents from SQL Server Reporting Services (SRS) Reports

Extending Project Server 2010 for Extranet Users

Posted By Posted by: EPM Partners on June 10, 2011

A common requirement for many SharePoint and Project Server deployments is to have an external facing interface using an alternate Forms based authentication method, the most common is using an ASP.NET SQL provider which since the 2007 version is the one of the simplest options. With 2010 however and Claims authentication this requires that you

Read More


Blog Posted In Blog Posted In: Project Server
Blog Posted In Comments Off on Extending Project Server 2010 for Extranet Users

Auto-publish of Task Status Updates in SP1

Posted By Posted by: EPM Partners on June 6, 2011

While investigating a solution for a customer who has a pretty common problem I came across another new feature to be included in Project Server 2010 Service Pack 1. The problem comes about from the requirement to regularly publish project schedules to ensure that reporting data is kept up to date, this is particularly important

Read More


Blog Posted In Blog Posted In: Project Server
Blog Posted In Comments Off on Auto-publish of Task Status Updates in SP1