Search Results

There are a few of you out there that have asked why the order of the Weeks in the OLAP cube have Week10 before Week6 – this hotfix addresses this ordering/sorting issue and a couple others. Description of the Office Project Server 2007 hotfix package (Pjsrvapp-x-none.msp, Pjsrvwfe-x-none.msp): October 25, 2011 This article describes the issues […]

Folks the October 25th, 2011 Project Server 2010 hotfix includes a few specific areas that you may have run across.  Consider these when choosing to deploy this hotfix, also make sure to read the complete Cumulative Update article (listed at the end of this posting). Description of the Project Server 2010 hotfix package (Pjsrvwfe-x-none.msp): October […]

Thank you all who joined my session on Project 2010:  Tips and Tricks that I delivered for MPUG last week.  Your e-mails and messages were nice and I am glad it was helpful.  Some of you asked about the recording and the Quick Access Toolbar link.  They have both been published…Here you go. Also let […]

Good Afternoon Folks, My webcast that I delivered for MPUG last week included reference to my Quick Access Toolbar sample.  I find it extremely helpful for better navigation and resource management with Microsoft Project 2010.  My Quick Access Toolbar will allow you to start your own standard toolbar and you can share it with your […]

If you have ever used SSRS, you’ve probably run across an issue where HTML tags are displayed in your reports output like so: (CHAR(13) + CHAR(10)1.&      Increase clarity on printed invoices, resulting in reduced manual intervention for scanning errors.  2).  One way to get rid of this is to locate the field in question, then […]

Meeting Announcement:  Join the MPUG Boston Chapter for… “How MS Project Saved My Life” (or at least helps me do my job!) Register Here Waltham, MA - On Wednesday November 30, 2011, The Boston Chapter of MPUG (Official Industry Association for Microsoft Project) will be holding a membership meeting.  This interactive presentation and discussion will […]

Folks, I have had several conversations with several clients, the MSFT product team, fellow peers and it all boils down to the fact that each organization has their own preferences when archiving projects. What do you do? I thought to include a link that is one way and I will also expand on this posting […]

For our Project Server 2007 folks out there:  This one is for you. Thanks to Brian and Microsoft for his blog:  http://projectserverblogs.com/?p=5272 Service Pack 3 (SP3) for Project and Project Server 2007 are now released and can be found at: 2007 Microsoft Office servers Service Pack 3 (SP3) and 2007 Microsoft Office servers Language Pack […]

Description of the Project 2010 hotfix package (Project-x-none.msp): October 25, 2011 http://support.microsoft.com/kb/2596495  Folks, this hotfix seems to address several issues that you may have seen and some that will save you heaps of time (and did not know about). Read on and let us know how your testing goes.   Also – Microsoft has let us […]

I was Performing an upgrade for a client recently when I encountered this error.  In the past when I received this error it was usually the result of my incorrectly typing the name of one of the four Project Server databases incorrectly.  This time, however, that was not the case.  Error message and resolution are […]

Quite often when writing reports that grab data from SharePoint lists, you have to deal with HTML tags showing up in your reports.  This function helps clean that garbage from the fields. Usage: ,dbo.DeHtmlize(MSP_EpmProject_UserView.[Current Status]) as [Current Status] USE [ProjectServer_Reporting] GO /****** Object:  UserDefinedFunction [dbo].[DeHtmlize]    Script Date: 03/22/2011 11:03:55 ******/ SET ANSI_NULLS ON GO SET […]

Folks – if you are a Project Server 2007 shop and your Data Analysis cube stops building – the following article will help you.  This may occur if you change your SharePoint server farm (servers or names).  Let us know if you have any additional questions. http://blogs.msdn.com/b/brismith/archive/2008/12/09/project-server-2007-has-your-cube-build-stopped-working-to-the-schedule.aspx Enjoy.

Folks there is a lot of buzz around Project Conference 2012.  We will be there will you?  Register today and secure your spot.  Get the most out of Microsoft Project and make sure to stop by and introduce yourself to the MS PROJECT NOW! team. -Jacques

When attempting to create a data source for performance point services I encountered this error.  The cause of this error has to do with setting up an unattended service account for PPS.  Do so as follows: Navigate to Central Administration Under Application Management, click Manage Service Applications Click on the PerformancePoint Service Application Click on […]

One of my clients asked if it was possible to make a shortcut of a Project Server project from the desktop.  Well by using command-line switches you can definitely open a project.mpp file.  I will let you know if it works for Project Server projects. For now, check out this information (provided by MSFT) on […]

Description of the Project Server 2010 cumulative update package (Project server-package): October 13, 2011 Cumulative Update link: http://support.microsoft.com/kb/2553049 Project Server 2010 hotfix package:  http://support.microsoft.com/kb/2553047 We recommend that you test hotfixes before you deploy them in a production environment. Because the builds are cumulative, each new release contains all the hotfixes and security updates that were […]

Many of us use SSRS (SQL Server Reporting Services) to generate and display Project Server data.  Well now thanks to Cristian and the Microsoft BI Team, we can leverage the PivotViewer Extension to create some very impressive reports. http://www.microsoft.com/BI/en-us/Community/BILabs/Pages/PivotViewerForSSRS.aspx http://www.microsoft.com/silverlight/pivotviewer/ Happy Reporting. -Jacques

Use ProjectServer_Published SELECT * FROM Versions WHERE VersionId = '00000000-0000-0000-0000-000000000000' ORDER BY Id DESC