none
Project Server SSRS report on project site list RRS feed

  • Question

  • Hi All,

    We are using project server 2013. We need to generate the consolidated report using SSRS on the issues list in all project site. In SSRS we can create a data source for a particular project site, but how to get items from all project sites. 


    Thanks in advance, Taj


    • Edited by arun_2014 Sunday, May 18, 2014 2:05 PM
    Sunday, May 18, 2014 2:04 PM

Answers

  • Hi Taj,

    In the Reporting table, you can query the dbo.MSP_WssIssue table that contains all issues data from the project sites.

    See reference:

    http://www.mssqltips.com/sqlservertip/2068/using-a-sharepoint-list-as-a-data-source-in-sql-server-reporting-services-2008-r2/


    Hope this helps,


    Guillaume Rouyre, MBA, MCP, MCTS |

    • Marked as answer by arun_2014 Monday, May 19, 2014 2:03 AM
    Sunday, May 18, 2014 2:16 PM
    Moderator

All replies

  • Hi Taj,

    In the Reporting table, you can query the dbo.MSP_WssIssue table that contains all issues data from the project sites.

    See reference:

    http://www.mssqltips.com/sqlservertip/2068/using-a-sharepoint-list-as-a-data-source-in-sql-server-reporting-services-2008-r2/


    Hope this helps,


    Guillaume Rouyre, MBA, MCP, MCTS |

    • Marked as answer by arun_2014 Monday, May 19, 2014 2:03 AM
    Sunday, May 18, 2014 2:16 PM
    Moderator
  • Hi Guillaume,

    Thanks for help. We have created some new field in issues and risks. But we could not find the files in ProjectWebApp [ProjectWebApp].[dbo].[MSP_WssRisk_OlapView] table. How can I get the new /additional fields created.


    Thanks in advance, Taj



    • Edited by arun_2014 Tuesday, May 20, 2014 8:31 AM
    Tuesday, May 20, 2014 8:26 AM
  • Hi All,

    How can I get the additional fields added to the issues / risks list.


    Thanks in advance, taj


    • Edited by arun_2014 Wednesday, May 21, 2014 9:10 PM
    Wednesday, May 21, 2014 9:10 PM
  • Taj,

    Unfortunately, additional fields in the Issues and Risks lists are not published to the reporting data store.

    Treb Gatte, Project MVP | @tgatte | http://AboutMSProject.com

    Saturday, May 24, 2014 9:01 AM
    Moderator