none
getSharepointlist item with project server database data. RRS feed

  • Question

  • Hi All,

    How to get data from sharepoint list and project server table on common filed as union query for coulmn  name project-name.

    using USSR services for reporting and Project server 2007 for server component.


    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Share Point Application Developer,TCS


    Tuesday, March 26, 2013 6:38 AM

Answers

  • I have got  solution.i was missing row-limit in camal query.so i was get only by default row,after putting row limit 300 all 200 record rendering in camal query.

    Cheers.

     

    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Share Point Application Developer,TCS

    Monday, April 1, 2013 5:19 AM

All replies

  • Hi,

    The default out of the box list fields (Issues, Risks etc.) are available in the Project Server Reporting database. These can be joined on the ProjectUID.

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Tuesday, March 26, 2013 9:23 AM
    Moderator
  • Hi,

    I have one custom list where so many data is thare.i need to get data from custom list.


    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Share Point Application Developer,TCS

    Tuesday, March 26, 2013 9:44 AM
  • Hi there,

    If the custom list is on the Project Site, a tool from CPS could help:

    http://www.cps.co.uk/What-We-Do/Pages/SharePoint-ReportLink.aspx

    Or you could use the SharePoint web services to get the data. In SSRS 2008 R2 there is a SharePoint List data source that enables you to connect to SharePoint lists.

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Tuesday, March 26, 2013 9:58 AM
    Moderator
  • Hi,

    I did not want to uses any tool.

    here i have link to find all step what ever i have done already,

    http://nikspatel.wordpress.com/2010/04/30/step-by-step-consuming-sharepoint-lists-data-in-the-ssrs-reports/

    In costume list  i have take user input as Project Name same like Project Center project name with custom status filed input.

    But here i have one report through project_report database and using another sub-report as data get from share pint list according parameter link as project name on rending report.

    Here i have get most of record according passing sub report parameter project name but in between record many record status come empty,but this project have status in custom list.


    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Share Point Application Developer,TCS

    Sunday, March 31, 2013 5:35 AM
  • I have got  solution.i was missing row-limit in camal query.so i was get only by default row,after putting row limit 300 all 200 record rendering in camal query.

    Cheers.

     

    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Share Point Application Developer,TCS

    Monday, April 1, 2013 5:19 AM