Search Results

Recently I was working with Excel Services and trying to publish an Excel Report to an document library in SharePoint.  Actual is was the Sample Reports library for Project Server 2010.  I basically while in Excel navigated File –> Save and Send –> Save to SharePoint.  In the resulting dialog box I pasted the Sample […]

DECLARE @mydate DATETIME SELECT @mydate = GETDATE() SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@mydate)),@mydate),101) , 'Last Day of Previous Month' UNION SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@mydate)-1),@mydate),101) AS Date_Value, 'First Day of Current Month' AS Date_Type UNION SELECT CONVERT(VARCHAR(25),@mydate,101) AS Date_Value, 'Today' AS Date_Type UNION SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(DATEADD(mm,1,@mydate))),DATEADD(mm,1,@mydate)),101) , 'Last Day of Current Month' UNION SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(DATEADD(mm,1,@mydate))-1),DATEADD(mm,1,@mydate)),101) , 'First Day of Next Month' GO

Hey folks, Many people have done this, and it seems there are several ways to do it.  Some people merely copy overwrite development databases (four PS2010 databases) with fresh production databases.  Others delete the development instance, and provision a new one using fresh production databases.  Of the two methods, the second is definitely the superior […]

This is a good query if you want all timesheet actuals, including those that may not have been updated via a republish of a project.   SELECT    TSR.ResourceName,         TSC.ClassName 'Project Classifications',         TSA.ActualWorkBillable 'AssignmentActualWork' ,         TSA.TimeByDay,         TSC.Type,         mtt.TaskName,         ISNULL(MTP.ProjectName, TSC.ClassName) 'ProjectName' FROM dbo.MSP_TimesheetActual AS TSA -- Stores planned & actual […]

I recently built an internal SharePoint farm consisting of the following servers: Server 1: Application Server Server 2: Project Server Application Server Server 3: Web Front End Server 4: SQL/SAS/SRS Server   After much work I was able to get the initial configuration for SSRS working.  When I went to create a datasource in a […]

Recently I deployed a four server SharePoint/Project Server 2010 farm.  Servers as follows: SharePoint Application Server 1 Project Application Server 2 SQL/AS/SRS Server 3 SharePoint Web Front End Server 4 Accessing the SharePoint site collections worked great.  When accessing Project Server, however, I occassionally encountered an error.  It was sporadic and could typically be resolved […]

OK, I was banging my head for about 3 hours this morning trying to get a multi-value parameter work in an SSRS report until I consulted a colleague.  He told me the I could set the filter at the Dataset level, rather than in the embedded SQL.  Do so as follows:   Create a parameter […]

Dear Community, Happy Friday.  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 data into insightful reports and dashboards: Microsoft Project Server 2010 Reporting with Excel Services written by Jean-Francois LeSaux and Steven Haden from Microsoft Consulting  Services. Creating Dashboards […]

As Gary Chefetz mentioned last week: One Small Check Box, One Giant Leap for Project Server; basically with the upcoming Project Server 2010 Service Pack (SP1) due at the end of this month you will now have the ability to “Automatically publish the updates” as shown below. I have been using this feature to demo […]

Thanks to those 400+ attendees on today’s MPUG Certification Series – it was a pleasure to present and I look forward to next week’s session.  Click here to register for June 30th’s session. This posting includes the two (2) mentioned helpful links and the other links contained in the presentation (so you will not have […]

Announcing Service Pack 1 for Microsoft Project & Project Server 2010   Today, the Office Division announced additional details of the upcoming Service Pack 1 (SP1) here. Service Pack 1 is on track for release at the end of June 2011. It will be available for all of the Office 2010 applications, including Microsoft Project […]

Technet released a very comprehensive, useful, and FREE guide on Project Server 2010 administration back on March 2011.  MPN has gone ahead and added a few modules which cover the installation and configuration of reporting.  You can download a copy here.

if you have a need to move or copy a Project Site or Project Workspace from one location to another, the two commands below will be very useful to you:   Command to back the site up to a file stsadm -o export -url "http://brismithv0832:8080/CAL/Project1" -filename "Cbackupsavesite.bak" –includeusersecurity –nofilecompression   Command to restore the backup […]

Fixed with April 2011 Cumulative Update!   The errors returned from the queue are as follows: Error ID: 23006 Error ID: 26000 Detailed error below - send it to the administrator for more detailed troubleshooting. <?xml version="1.0" encoding="utf-16"?> <errinfo> <array name="rejectedTimesheetLines" type="System.Guid"> <item value="c1ceebb4-cb2d-0a3a-1672-12f252da3df5"> <error id="10000" name="GeneralItemDoesNotExist" uid="6d4f206a-49b1-43cf-bd8f-af2d84c22e7d" /> <error id="10000" name="GeneralItemDoesNotExist" uid="bec86fdb-b855-45e5-8d66-77078f724e10" /> <error […]

I had a client recently who was receiving en error when trying to submit time via the Project Server 2010 timesheets in SEM mode.  After some research, we discovered that the root cause appeared to be that the person was submitting time that was after the specified finish date of the task.  We had her […]

IIf([Duration Variance] > 0.25 * [Baseline Duration], "Duration Variance Greater than 25% of Baseline Duration", IIf([Duration Variance] > 0.15 * [Baseline Duration], "Duration Variance Greater than 15% of Baseline Duration", "Duration Variance Less than 15% of Baseline Duration"))

I was recently doing some PowerShell work, and being a newbie I was stuck.  The issue was I could only see a portion of the available commands.  None of the SharePoint related commands I needed were present.  To rectify, I merely navigated Start –> Administrative Tools –> Windows PowerShell Modules.  Once I did this the […]

From Capacity planning in Project Server 2010 (white paper) http://technet.microsoft.com/en-us/library/ff686784.aspx