none
Where is data stored for project subsites RRS feed

  • Question

  • I'm trying to access data for project juornal that is in a project subsite.. Where is this data in SQL 2008 R2 we're using project server 2010. I've look in the SDK info but no luck. Please HELP!!!
    Wednesday, May 15, 2013 7:05 PM

All replies

  • Hi

    Depends what data you are after exactly. Risks, Issues and Deliverables data is visible in the reporting database/olap cubes (default Microsoft fields within these lists are at least).

    Other custom lists you may have, you should use something like report builder 3.0 and create an SSRS report using the SharePoint list datasource type, or via XML. Some information here on that;

    http://nearbaseline.com.au/blog/2010/02/reporting-workspace-lists-directly-from-sharepoint/

    Hope that helps.


    • Edited by Rob Hardy Wednesday, May 15, 2013 8:58 PM
    Wednesday, May 15, 2013 8:57 PM
  • In addition to Rob's information, other data like documents and etc is stored in content database.


    Hrishi Deshpande – Senior Consultant DeltaBahn
    Blog | < | LinkedIn

    Please click Mark As Answer; if a post solves your problem or Vote As Helpful if a post has been useful to you.This can be beneficial to other community members reading the thread.

    Thursday, May 16, 2013 2:29 AM
    Moderator
  • First of all Thanks, Okay this my confusion My first data source is accessing SQL project report DB The other is a data source accessing a SPlist where my jounral data is. My confusion is list has no project ID so I can't associate it back to the report. Data Source Properties: MS sharepoint list Connection String: http://sharepointdev/engineeringprojects/2 Test Project  plus I have multiple project that I need journal data for...  I've attached apart of the report if that helps or am I confusion the this up...

    Large-Cabin Sustaining

    RQAAT.DI

    Status: Active

    Project

    AIP

    Priority:

    Project Owner

    Introduce Type I Grease to Replace Type II Grease on all GAC AC

    Earvin Hamilton

    Task

    1/0

    Planned

    Replanned

    Actual

    Root Cause: ​Conflicting grease callouts on supplier drawings and maintenance manuals between GV/G450/G550 and G650.&#160; Grease types cannot be mixed.</p>

    Corrective Action: ​GV/G450/G550 use MIL-PRF-23827 TYPE II grease for component maintenance.&#160; Industry trend is to use TYPE I.&#160; G650 uses TYPE 1&#160; on most applications.&#160; Standardize models by using TYPE 1 in all applications</p>

    Schedule (Last / Next 30 Days)

    Resource

    Planned

    Replanned

    Actual

    Tech Pubs to complete AINs / AMMs for Interim Plan to ensure only Type II references are called-out (except Type I for NWS Actuator and Collar)

    06/30/13

    06/30/13

    06/30/13

    Make Corrections to Grease part # call-outs in CAS-Prod Buyer & Mtl Planner

    03/28/13

    12/31/13

    12/31/13

    AR Support: Review of x100 documentation

    11/28/12

    12/31/13

    12/31/13

    Drawing Revision (Doors): X-100 EO for Doors ready for OB

    09/12/12

    05/30/13

    05/30/13

    Drawing Revision (Powerplant): X-100 EO for Powerplant Components ready for OB

    03/01/12

    05/30/13

    05/30/13

    Drawing Revision (Flight Controls): X-100 EO for Flight Control Components ready for OB

    01/26/12

    05/30/13

    05/30/13

    Drawing Revision (Landing Gear): X-100 EO for Landing Gear Components ready for OB

    01/19/12

    05/30/13

    05/30/13

    Thursday, May 16, 2013 4:58 PM
  • Hi

    Follow the link I applied above, it shows how to do everything you need;

    http://nearbaseline.com.au/blog/2010/02/reporting-workspace-lists-directly-from-sharepoint/

    This guide goes through XML datasource, but you can use the SP List Datasource.

    Instead of using the XML way of retrieving data in the mentioned link, you would basically connect to the URL of a project site using the SP List datasource, then build the query using the designer, then after its built, click ok then go back into the SP List datasource and change it to [@ProjectWorkspaceInternalHref]

    This will then pass the selected ProjectUID and Project URL into the SP List datasource.

    It takes some playing around, but the information is definitely there in that link.


    • Edited by Rob Hardy Thursday, May 16, 2013 5:40 PM
    Thursday, May 16, 2013 5:38 PM