We’re Back (and with instructions on creating a Burndown Report)!

Hi, I’m Heather O’Cull, another program manager on the Project team.  In case you’re wondering what happened to Treb, he is still here but has decided to pass the blog on to give more variety to it.  Big thanks to Treb for all the great posts and hopefully he’ll still be up for doing some…

30

Visual Project Planning and Reporting

In case you weren’t aware of this, you can use the WBS Modeler tool to visually model and plan your projects or to validate the current structure of your project.  The tool uses Visio 2007 and Project 2007 to do this.  Ok, I haven’t used this yet.  I’m in the process of installing it now. …


Report Pack – Update to the Timesheet Audit Report query

It appears part of the where clause is missing on the published Timesheet Audit report.  The result is that the weekly totals are all the same for each resource. To correct this, replace the SQL with the code below.  The addition is in bold below. SELECT MSP_EpmResource.ResourceName, MSP_TimesheetPeriod.PeriodName, MSP_TimesheetPeriodStatus.Description AS PeriodStatus, MSP_TimesheetStatus.Description AS TimesheetStatus, SUM(MSP_TimesheetActual.ActualWorkBillable)…


What happened to the URL at the bottom of my alerts?

They’re gone?  Yes, it’s true.  They’ve been removed in the 2007 release from all alerts and reminders.  Why?  We had several reports where providing this link to the end user to navigate to PWA was creating problems.  The base issue was which url is correct for a given user? For example, you have a system…


SQL Server Reporting Services Report Pack for Project Server 2007

This post contains a zip file attachment which is the SQL Server Reporting Services(SSRS) 2005 report pack for Project Server 2007.  This attachment contains 9 items total:  One overview document describing the setup for each report as well as any new custom fields/lookup tables that are required to make these reports function.  Seven PDFs which are sample output for each…


Reporting Database Documentation Published

If you are interested in writing reports over the Project Server 2007 reporting database, Jim Corbin has published some documentation on the database.  You can find it here:  http://blogs.msdn.com/project_programmability/archive/2006/12/05/reporting-database-diagrams.aspx


Visual Reports

Hello everybody.  I’m Heather O’Cull and I’m also a program manager on the Project team.  This week I decided to lock Lidiane out of her office and take over control of the blog to write about a new feature that I think is pretty cool – Visual Reports.   Visual Reports is a new feature…


Cube Building Services Overview

For our first feature discussion, I will introduce you to Project “12” Cube Building Services that represent a part of our offerings for Enterprise Project Management Reporting. It also happens to be the feature I own, so I am very excited to share with you the work we have done.   Project Server 2003 ships…

26