Project Server 2010 Reporting with Excel Services & Creating Dashboards white papers

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 for Microsoft Project Server…

0

Project Server 2007 Report Pack II – An incredible asset you should all leverage

This is a blog post that is worth checking out! My colleague Jan Kalis just announced the release of the Project Server 2007 Report Pack II (recorded webcast and demo here). Why is it the best thing since slice bread? Well check out the following list of SQL Server Reporting Services it contains (and to…

4

SQL Server 2008 R2

Announced today at TechEd: SQL Server 2008 R2, will be a great enhancement to Project Server deployment from a reporting perspective, why? Check the following preliminary resources (more info here: R2 Benefits by Workload): Self Service Analysis with “Project Gemini” Self Service Reporting with SQL Server 2008 R2 Reporting Services Register for the Community Technology…

0

Announcing the release of the April Cumulative Update for Project and Project Server 2007

[Updated December 17, 2009: Official HW and SW req are now published in TechNet: http://technet.microsoft.com/en-us/library/ee683978(office.14).aspx]  We are happy to the announce the release of the April Cumulative Update (April CU). Cumulative Update (CU) are scheduled every two months, so the next releases will be at the end of June, August, October, December, etc…  Please note that…

3

Fields required to run Project List and Project Detail Reports

I posted this set of sample SQL Server Reporting Services (SSRS) reports almost a year ago: New SQL Reporting Services Sample Reports for Project Server, and due to popular demand finally documented the required custom fields and lookup tables to run the following two reports: Project List Project Detail If you are looking for a…

1

How to report Project Risks at a Program Level?

<Update June 2010> As a reminder as mentioned in this MSDN article: SharePoint Database Access “process for acquiring that data should be through the built-in SharePoint object model, and not by using any type of query to the database.” hence a much more elegant and supported solution to address this request is to use the…

0

How to upgrade your existing Microsoft Project VPC running on SQL 2005 to SQL Server 2008

I’m sure you have seen these cool SQL Reporting Services 2008 reports: Microsoft SQL Server Reporting Services 2008 – Sample Project Server Reports and would like to do the same in your favorite EPM demo VPC or you just have plenty of free time during this time of the year and you are looking for…

0

Microsoft SQL Server Reporting Services 2008 – Sample Project Server Reports

Following the release of this sample SQL Server Reporting Services 2005 report pack: New SQL Reporting Services Sample Reports for Project Server, I have just updated two sample reports (Risks and Portfolio Status, attached below) to illustrate the use of the Gauge which comes with SQL Server Reporting Services 2008. I used SQL Server 2008…

3

How to secure your Project Server Reporting Services Reports

It seems SQL Server Reporting Services (SSRS) is broadly used today in Project Server deployments to build custom reports and extract all the gold nuggets from our relational and decisional data stores (SQL Server Analysis Services cubes), specially when I see the success on this post: Services Sample Reports for Project Server This week I…

0