Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Reporting   (RSS)
Tuesday, January 13, 2009 9:09 PM

Identifying Surrogate Timesheets in the Reporting Database

When we shipped Project Server 2007 we made sure that timesheet data was readily available to query in the Reporting Database, however one thing that we didn't do was make it super easy to spot a surrogate timesheet (defined as a timesheet entered on
Posted by PatrickConlan | 1 Comments
Thursday, April 10, 2008 6:30 PM

New SQL Reporting Services Sample Reports for Project Server

Hello, Christophe just released the reports that ship with the updated EPM 2007 VPC: http://blogs.msdn.com/chrisfie/archive/2008/04/10/new-sql-reporting-services-sample-reports-for-project-server.aspx Chris Technorati Tags: Project Server , Reporting
Posted by Chris Boyd | 0 Comments
Monday, March 31, 2008 7:32 PM

Connection Strings…

Hey, Here is a great post: http://projectserver.cz/cms/index.php?itemid=35 It shows how to get the connection string to the Project Server 2007 Reporting Database (and the other three databases which are not supported programming interfaces). This is
Posted by Chris Boyd | 2 Comments
Thursday, February 07, 2008 1:09 AM

Project Server 2007 - Project Server Developer Community Expanding

Leveraging the development aspects of Project Server 2007 spans a wide range of skills. PWA customizations (ASP.NET), workflow development, line of business applications integration using the PSI, extending Project Server functionality using server side
Posted by Chris Boyd | 1 Comments
Thursday, January 03, 2008 6:43 PM

Implementing My Tasks “Read Only Custom Fields”

Using Project Server 2007’s Reporting Database and SQL Server Reporting Services 2005 The attached report illustrates how to safely query the RDB to allow team members to see a read only view of task assignment data. We’ve picked a random task custom
Posted by Chris Boyd | 1 Comments
Attachment(s): Task Assignment Information.zip
Thursday, January 03, 2008 5:56 PM

Reporting Database Extensions: Local Custom Fields Custom Code

Introduction This custom solution builds on the Project Server 2007 server-side event model to cache a report-friendly copy of Project Local Custom Fields in the Reporting database. The following data is cached: Task Text Custom Fields (with and without
Posted by Chris Boyd | 2 Comments
Attachment(s): Local Custom Fields in RDB.zip
Monday, December 10, 2007 4:06 AM

Publishing Projects based off a Project Custom Field Value

Hello, As part of the development process for the next version of Project, we are heavily relying on Project to manage all the work that is happening across team. As part of the process, we require up to date status reports. All the work is spread across
Posted by Chris Boyd | 2 Comments
Attachment(s): PublishProjects.zip
Monday, November 12, 2007 11:22 PM

Local Custom Fields

Introduction This post contains interim documentation for tables in the Published database of a RTM-edition Project Server 2007 installation. Entities in this schema are subject to change without notice. This documentation is made available on a “best
Posted by Chris Boyd | 1 Comments
Friday, October 19, 2007 11:53 PM

Check out the Post on Scalable Issues & Risks Report

It seems that somehow I messed up and the post " Scalable Issues & Risks Report " ended up showing up in the past. So in case you missed it: http://blogs.msdn.com/project_programmability/archive/2007/09/28/scalable-issues-risks-report.aspx Chris
Posted by Chris Boyd | 1 Comments
Friday, September 28, 2007 10:04 PM

Scalable Issues & Risks Report

Introduction Out of the box the Issues & Risks components of Project Server 2007’s collaboration functionality have an architectural problem which surfaces when 100’s of Project Server Workspace sites are created. This problem is forced by the need
Posted by Chris Boyd | 2 Comments
Attachment(s): Issues and Risks Report.zip
Thursday, September 13, 2007 5:36 PM

Project Conference 2007 is Quickly Approaching

I just wanted to give a quick update about the Project Conference that is coming up at the end of October in Seattle. This is going to be our biggest conference ever! With sessions covering everything from how to get started with Project to managing a
Posted by Chris Boyd | 0 Comments
Friday, September 07, 2007 10:49 PM

Improve the Performance of Building the Project Server Data Analysis Cube

Jack Li has passed along a great tip on how to improve the performance of building the Project Server Data Analysis Cube: Recently we have worked with a big enterprise customer using Project Server. They ran into an issue where Project Server reporting
Posted by Chris Boyd | 3 Comments
Thursday, May 24, 2007 10:09 PM

Getting at the Task Time Phased Data

I have been asked many times how to get the task time phased data from the PSI. Unfortunately there is no way to get this through the PSI. I suggest that you either go to the RDB for this information or the cubes. Here is a quick example. I created a
Posted by Chris Boyd | 2 Comments
Filed under: , ,
Thursday, May 17, 2007 6:54 PM

Syncing Project Workspaces with the RDB

It has been a while since I have done a blog post, so I figured I would share with you something that I am currently working on. We have run into the scenario where users are updating information on Project Workspaces and Project Manager wants to report
Posted by Chris Boyd | 2 Comments
Filed under: , ,
Thursday, April 12, 2007 12:16 AM

Project Conference

I just wanted to give everyone a heads up about the upcoming Project Conference. Details can be found here: http://www.msprojectconference.com/ There will be a Developer/IT Professional track that we will be presenting on a verity of development topics
Posted by Chris Boyd | 0 Comments
More Posts Next page »
 
Page view tracker