none
Sharepoint 2010 Integrated Reporting with Project Server 2010 RRS feed

  • Question

  • Hi,

    I have a custom (ssrs) project status report to deploy and wanted to use Project Detail Page to display it. Is there anyway where the report parameter can auto match and render report in the project detail page?

    Thanks in adavance.

    SJ

    Tuesday, September 11, 2012 2:29 PM

Answers

  • Thanks Amit.

    Looking at the link you sent me about passing the parameters...I really don't want a custom ribbon. I want show the report automatically in a PDP and the query looks like that it needs to be hard coded?

    Hi SJ--

    We have done similar work for using the QueryString filter web part & Report viewer webpart on PDP page.
    On a PDP Page, You can add two webparts 
    1. Filter> Query string filter
    2. SQL server report web viewer webpart

    Set the RDL file in SQL server report web viewer web part that requires  ProjUID parameter & You can modify the query string filter webpart > Connection > send the parameter to SQL server report web viewer webpart with ProjUid. When loaded, it picks up the parameter from ProjUID of querystring URL & loads the data in Report viewer webpart.
    Ref: http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/1e5488a7-3aa3-4708-a495-bf326163c6a9

    Hope that helps.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    • Marked as answer by SJ_PPM Monday, September 17, 2012 1:30 PM
    Monday, September 17, 2012 11:00 AM

All replies

  • I would add the "SQL Server Reporting Services Report Viewer" to Use the Report Viewer to view SQL Server Reporting Services reports.

    Open PWA --> Server Settings --> project details pages --> add the "SQL Server Reporting Services Report Viewer" web part and Use the Report Viewer to view SQL Server Reporting Services reports.

    Is there anyway where the report parameter can auto match and render report in the project detail page?

    how do you want to do this? can you give more details?


    Cheers. Happy troubleshooting !!! Sriram E - MSFT Enterprise Project Management

    Wednesday, September 12, 2012 2:44 AM
    Moderator
  • Hi SJ--

    Please see Alex's excellent article:
    http://epmsource.com/2011/01/31/invoke-project-status-reporting-direct-from-the-ribbon/

    Based on the projUid from querystring, you can set the parameter in SSRS report , when loads picks up the projuid & get the result.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Wednesday, September 12, 2012 5:12 AM
  • Sorry about the late reply.

    Thanks Sriram and Amit

    I think that is what I needed is what Amit pointed out, but unfortunately I have set it in Reporting Services in Native Mode already!

    Any tips in this situation? Also, I saw what is required to setup reporting services in integration mode!!! Gosh!!! That is one time consuming task on a multi tie environment!

    SJ

    Thursday, September 13, 2012 10:35 AM
  • Hi SJ--

    If you want to have the SSRS reports in SSRS report viewer webpart on sharepoint/project server farm, You'll need to have the Sharepoint integrated mode. Please see below article:
    http://technet.microsoft.com/en-us/library/hh833726.aspx

    Apart from that,You may use the RSWebParts.cab (I haven't tesed though)

    Requirements for using the Report Viewer and Report Explorer Web Parts include the following:
    Supported versions of SharePoint products and technologies include Windows SharePoint Services 2.0, 3.0, and SharePoint Foundation 2010; Microsoft SharePoint Portal Server; and Microsoft Office SharePoint Server 2007 and SharePoint Server 2010.
    The report server version must be SQL Server 2005 Reporting Services or later.
    The report server must run in native mode. You cannot use the Report Explorer and Report Viewer Web Parts to connect to or view reports on a report server that runs in SharePoint integrated mode. For more information about modes


    http://msdn.microsoft.com/en-us/library/ms159772.aspx

    If you are from development background, Would suggest to create a webpart to have it in PDP page where based on query string, it can get the projUID & based on the SQL query that you used in SSRS report, it pulls & shows  the data on webpart.

    Hope that helps.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Thursday, September 13, 2012 11:04 AM
  • Thanks Amit.

    Looking at the link you sent me about passing the parameters...I really don't want a custom ribbon. I want show the report automatically in a PDP and the query looks like that it needs to be hard coded?

    Sunday, September 16, 2012 5:57 AM
  • Hi Sriram,

    I want to show the custom status report automatically based on the project uid. I have got the report viewer webpart up and running, ut I still have to select the project from the list menu to run the report from PDP.

    Any help will be highly appreciated.

    Thank you,

    SJ

    Sunday, September 16, 2012 6:06 AM
  • Thanks Amit.

    Looking at the link you sent me about passing the parameters...I really don't want a custom ribbon. I want show the report automatically in a PDP and the query looks like that it needs to be hard coded?

    Hi SJ--

    We have done similar work for using the QueryString filter web part & Report viewer webpart on PDP page.
    On a PDP Page, You can add two webparts 
    1. Filter> Query string filter
    2. SQL server report web viewer webpart

    Set the RDL file in SQL server report web viewer web part that requires  ProjUID parameter & You can modify the query string filter webpart > Connection > send the parameter to SQL server report web viewer webpart with ProjUid. When loaded, it picks up the parameter from ProjUID of querystring URL & loads the data in Report viewer webpart.
    Ref: http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/1e5488a7-3aa3-4708-a495-bf326163c6a9

    Hope that helps.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    • Marked as answer by SJ_PPM Monday, September 17, 2012 1:30 PM
    Monday, September 17, 2012 11:00 AM
  • Thank you! Thank you! Thank you!

    That is exactly what I was after! Perfect!!!

    You are such a star!

    SJ

    Monday, September 17, 2012 1:30 PM
  • Glad that I was able to help.

    You are more than welcome :)

    Thanks,


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Tuesday, September 18, 2012 4:13 AM