locked
Project Server Reporting RRS feed

  • Question

  • Hello,

    I'm using Project server 2007 SP2.

    After the success of creating and publishing project plans on the server, I'm trying now to know if i can make a custom reports on PS, related to all projects i have on PS (like how many issues, tasks and risks i have in a project, how many resources i have in a specific project, and so on)....is that possible to do? and how can I start?

     

    regards, 

    Scott.

    Thursday, July 8, 2010 10:58 AM

Answers

  • Hi Scott,

    Right, firstly I would try to build the OLAP Cube..... use the following Technet article to configure and build the cube - http://technet.microsoft.com/en-us/library/cc197552(office.12).aspx

    Once you have done this, we can then advise you to on how to create reports.

    Also Andrew is also correct - you could create a Project Center view.  This is done by going to PWA - Server Settings - Manage Views - Create a new view.  Here you can either create a Project Center View (portfolio view of all your projects) and view information which you require / group your projects.

    If you are able to give an exact report that you are trying to generate we can give you some clear direction.

    Regards,

    Dharmesh

    Friday, July 9, 2010 1:40 PM

All replies

  • Hi Scott (again :-) ),

     

    OK, so what you are trying to achieve is more thn possible.  There are two main ways I would suggest doing this:

     

    1. Using Data Analysis views by creating an OLAP Cube and reporting against this.  It is possible to create a view from here to fulfil your requirements.  The following Technet article will help you to configure this - http://technet.microsoft.com/en-us/library/cc303402(office.12).aspx
    2. SQL Reporting Services.  To get started with this there is something known as the Project Server Report Pack (http://msdn.microsoft.com/en-us/library/bb428831(office.12).aspx) which has been released by Microsoft which is a starter kit on some pre-canned reports to get you going.

     

    To begin with I hope that this helps.

     

    Regards,

     

    Dharmesh

    Thursday, July 8, 2010 11:04 AM
  • In addition to Dharm's suggestions, have you already tried using custom fields
    and Project Center views? Things like # of tasks or variance can all be
    indicated there with custom enterprise formulas.
     
    Just checking.
     
     
    - Andrew Lavinsky
     
     
    Thursday, July 8, 2010 11:22 AM
  • Thanks All,

    Dharmesh, how are you again :)

    I'm trying to follow the instruction for making a report, but until now, it still hard for me to do it...i don't know, maybe i make some mistakes.

    Can you simplify it more for me.. I mean can you give me an example of how to report on the number of tasks in a project...step by step

     

    Thanks in advance

     

    Scott.

    Friday, July 9, 2010 1:32 PM
  • Hi Scott,

    Right, firstly I would try to build the OLAP Cube..... use the following Technet article to configure and build the cube - http://technet.microsoft.com/en-us/library/cc197552(office.12).aspx

    Once you have done this, we can then advise you to on how to create reports.

    Also Andrew is also correct - you could create a Project Center view.  This is done by going to PWA - Server Settings - Manage Views - Create a new view.  Here you can either create a Project Center View (portfolio view of all your projects) and view information which you require / group your projects.

    If you are able to give an exact report that you are trying to generate we can give you some clear direction.

    Regards,

    Dharmesh

    Friday, July 9, 2010 1:40 PM