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

hi~

where is "MSPLT_Organization_UserView" table??

Thank you...

Following this post ( New SQL Reporting Services Sample Reports for Project Server ), please find below

Hi,

the reports look great - what steps would I need to follow to make the available in my customized environment? Guess there are lookup tables etc to create? I wonder if you have a step-by-step install procedure.

Thanks in advance

I recently posted a series of SQL Server Reporting Services (SSRS) reports that are used in our newly

Hi Chris,

I can't undestand how and where you've created a LT 'Organization'.

I'm getting the following error:

Query execution failed for data set 'dsPortfolio_Status';

Invalid column name 'Organization'

Invalid column name 'ParentLookupMemberUID'

Please  can you tell me what do I need to create so that the reports work?

Where have you created a Lookup table Organization? PWA, or SQL (where?) ?

When you create this, do you need to feel in in the projects? Is that right?

I also need  to know how do you create a report with a speedometer. IS it an image?

thanks in advance

Are you a Microsoft partner? Would you like to see these reports live ?: New SQL Reporting Services Sample

A few weeks ago, I did my 200th post since starting this blog, so following Brian Smith’s initiative

Following the release of this sample SQL Server Reporting Services 2005 report pack: New SQL Reporting

Dear Christophe or any other member,

thanks a lot for providing the report pack. Very good work. Like others, I am facing the same problems with the database model/settings. We would like to use the reports with our own reporting database.

What do we have to do to get the reports working?

Whick lookup tables do we have to create (Which records have to be inserted)?

What else has to be changed to the database? Additional tables/columns?

Hope you can help us. It would help a lot!

Thanks in advance. Best regards,

Guido

Hi Christophe,

these reports are already working. As your reports fulfill more of our requirements, we would like to use these reports as well. At a first step, do I have to create a lookup table called "Organization" in PWA? If yes, which fields and records do I need?

Do you have SQL update/create scripts for the modification of the "original" reporting database?

Best regards,

Guido