SQL Server Reporting Services Report Pack for Project Server 2007

Looks nice.

jfraser — Wed, 31 Jan 2007 04:01:05 GMT

Looks good. I like the idea for storing time phased project status data. It raises a lot of interesting thoughts: Could certain values get programatically copied into a bunch of time-phased enterprise codes, and perhaps use event code to secure these so user editing is not allowed? Pretty powerful possibilities.

The reporting database seems to have made created a split in reporting for Project Server. Some reports from 2003 are now much easier: time phased data doesn't need to be decompressed, easier to join to custom codes, &c. but many reports are now much more difficult. Reporting on the task update work flow, for example, looks to be much harder. (I haven't looked to see if any of the timesheet tables include task updates, but I'm assuming they don't.)

Custom data sources for SSRS, using the PSI, I suppose. It's very tempting to look straight into the published database to get at some of this. I see the tables there just waiting to be loved...

-j

re: SQL Server Reporting Services Report Pack for Project Server 2007

Treb Gatte — Thu, 01 Feb 2007 01:44:41 GMT

Yes, you could do some really cool stuff with the timephasing of status data. :-)

Also, bear in mind that we will not be documenting the published database as the RDB is to be used for all reporting.

re: SQL Server Reporting Services Report Pack for Project Server 2007

Kelly Chu — Fri, 09 Feb 2007 01:02:59 GMT

Looks like the Timesheet Audit Report "TotalWork" column is just adding up all hours across all Timesheet reporting periods. Thus, all Total Reported Hours for each period is the same.

This seems like a bug in the reporting as it makes the Timesheet Audit Report uninformative.

Is this planning on being fixed?

re: SQL Server Reporting Services Report Pack for Project Server 2007

Treb Gatte — Fri, 09 Feb 2007 11:51:56 GMT

Kelly,

I'll take a look at that as it should be grouping by reporting period. Also, can you send me your email address by clicking the email link in the blog header?

Thanks!

--Treb

Creating Deliverable Reports

Project Programmability — Sun, 25 Feb 2007 00:56:28 GMT

I have had many questions with regards to the Deliverables feature and reporting. If your not familiar

Why use SQL 2005 SP2 with Project Server 2007: Reporting Services Add-in

Steven Haden's Blog — Sun, 01 Apr 2007 22:48:47 GMT

The SQL 2005 SP2 has just been out for a couple of weeks now.. It brings a nice new feature in terms

re: SQL Server Reporting Services Report Pack for Project Server 2007

sree — Mon, 23 Apr 2007 22:01:51 GMT

I would like to know if there is a feature in Project Server 2007 to schedule reports, so the management doesn't have to go to web access for report. The idea is to get email notification of the project progress automatically. Any body has any idea if this can be done on project server 2007

re: SQL Server Reporting Services Report Pack for Project Server 2007

milnerphil — Thu, 24 May 2007 16:43:51 GMT

It seems that some formatting from project server is removed in the Report Pack. Is this a limitation, for example not bolding a particular word or phrase, that we have to accept or am I just missing it?

re: SQL Server Reporting Services Report Pack for Project Server 2007

PatrickConlan[MS] — Tue, 03 Jul 2007 19:54:51 GMT

Sree - Reporting Services will happily schedule a report for you and drop it to a web site or file share and email a notification to the reports subscribers.

Milnerphil - you'll need to add your own annotations, we don't pass project professional task highlighting and font settings through right now - interesting thought though!

Thanks....pc

re: SQL Server Reporting Services Report Pack for Project Server 2007

Brenden Ward — Wed, 01 Aug 2007 16:33:52 GMT

We are trying to get reports out of project 2007 basically users are puting in administrative time into timesheets and we want to view a report which shows all this data. Ideally be able to see how must time is being spent on each administrative task.

Has anyone any experience of this type of report and if they have what fields do we use to pull in all the data.

Thanks

Brenden Ward

re: SQL Server Reporting Services Report Pack for Project Server 2007

MAHENDRA — Mon, 06 Aug 2007 11:23:11 GMT

HI,

Looks like the Timesheet Audit Report "TotalWork" column is just adding up all hours across all Timesheet reporting periods. Thus, all Total Reported Hours for each period is the same.

This seems like a bug in the reporting as it makes the Timesheet Audit Report uninformative.

Is this planning on being fixed?

re: SQL Server Reporting Services Report Pack for Project Server 2007

MAHENDRA ISHWAR RANE — Mon, 06 Aug 2007 11:24:01 GMT

HI,

Looks like the Timesheet Audit Report "TotalWork" column is just adding up all hours across all Timesheet reporting periods. Thus, all Total Reported Hours for each period is the same.

This seems like a bug in the reporting as it makes the Timesheet Audit Report uninformative.

Is this planning on being fixed?

re: SQL Server Reporting Services Report Pack for Project Server 2007

KETAN R PATEL (SURAT) — Thu, 16 Aug 2007 14:21:23 GMT

re: SQL Server Reporting Services Report Pack for Project Server 2007

Amit Joshi — Thu, 27 Sep 2007 07:46:11 GMT

hi i downloaded the zip and tried using it but there is no project file in the zip...is the project file missing cause i can see just .rdl files and a solution file. When i try to open the solution it gives me an error mentioning no project available.

re: SQL Server Project Server 2007 on the same computer

najib — Mon, 05 Nov 2007 16:31:12 GMT

hallo,

i have a question maybee some one can help,

Can install project server and SQL one same server of should installed on different computers

Thanks in advanced

re: SQL Server Reporting Services Report Pack for Project Server 2007

KarenF — Mon, 10 Mar 2008 23:19:32 GMT

Hello,

I read the instructions on how to configure the database and publish the reports to the SSRS instance, but how do you link these into PWA 2007 so users can use them?

re: SQL Server Reporting Services Report Pack for Project Server 2007

Frank — Fri, 11 Apr 2008 12:09:49 GMT

Hi,

The SRS Reports are a great way to get the data out of Project Server and I created quite a few usefull reports, but I'm still struggeling getting out information regarding:

- Pending MyTasks that should be submitted by the resources. We want to check if all resources have submitted their hours to the PM's

- A complete Timesheet overview per resource that also puts surrogate Timesheet information behind the corresponding resource (surrogate data seems to disappear in the Reporting database)

Has anybody some experience with these specific reporting topics?

Rgds,

Frank

re: SQL Server Reporting Services Report Pack for Project Server 2007

Ron — Wed, 30 Apr 2008 20:42:06 GMT

Is there a way to add the Calendar items from the Project Workspace? It's capturing Risks, issues and deliverables but we would also like to capture the calendar items. Thoughts?

re: SQL Server Reporting Services Report Pack for Project Server 2007

subha — Fri, 23 Oct 2009 09:48:17 GMT

We are using EPMS for Task Sheet rather than the Time Sheet. I would need to create the report for the project that list the available task name,resource allocated, work completed.

I am using the Reporting database and the tables i'm accessing are Msp_epmproject_userview,

Msp_epmtask,Msp_epmassignment and Msp_epmresource.

When i update any task details, it is not reflecting in the reporting database.

Can any one help me out in this?