locked
Project Server 2010 - Can't find Project Site list information in the SQL Database RRS feed

  • Question

  • I am using Project Server 2010. I have created several custom lists in the Project Site Template which are being populated by users in the production environment. I need the list data to come across into my Status Report. However, our BI people cannot find the lists within the SQL database. Is there something special that needs to be done to a list to allow reporting from the SQL database? Where can we find my lists within the SQL database?
    Wednesday, December 21, 2011 10:21 PM

Answers

All replies

  • I am using Project Server 2010. I have created several custom lists in the Project Site Template which are being populated by users in the production environment. I need the list data to come across into my Status Report. However, our BI people cannot find the lists within the SQL database. Is there something special that needs to be done to a list to allow reporting from the SQL database? Where can we find my lists within the SQL database?


    At IPMO we find this is a very common customer requirement.  There are many scenarios with Project Server where you will need to report on custom lists that have been added to the site template - and in many cases produce reports that consolidate all of these lists accross the PWS site collection.  You can create reporting serivces reports that target individual SharePoint lists, but reporting accross a SharePoint site collection that doesn't use content types (like Project Server) can be more difficult.

    <plug>

    In this case IPMO deploys a SharePoint add-on called DataMiner which mirrors the content of these custom lists (or any list) in real-time from all webs in your Project Workspace Site collection into a reporting database for easy report authoring.  It also has many additional features such as stripping of HTML, resolving user/group field names, and prevents the users from altering/deleting fields in lists that have reports against them.  We deploy this tool at nearly all of our customer sites to provide almost self-service reporting.  Read here for more info. There is a trial version to try out - let me know if you have any trouble.

    </plug>

    Regards,

       James.

     


    James Boman - http://www.boman.biz Software Consultant for IPMO - http://www.ipmo.com.au
    Wednesday, December 21, 2011 11:56 PM
  • Hi,

    Further to James's advice, if you don't need to consolidate the lists together and are using SQL Server 2008 R2, you can leverage the SharePoint List Connection type in SSRS (http://msdn.microsoft.com/en-us/library/ee633650.aspx)

     


    Alex Burton
    www.epmsource.com | Twitter
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    • Marked as answer by smokief Thursday, January 12, 2012 5:42 PM
    Thursday, December 22, 2011 12:56 AM