locked
Error integrating SSRS Reports into PerformancePoint (pic) RRS feed

  • Question

  • I am getting the following error when I try to add my integrated SSRS reports as performancepoint content.

    I also have looked on the sharepoint server for this and can't find any error in the logs that seems to relate to it.

    Many thanks!

    Wednesday, August 29, 2012 6:46 PM

Answers

  • You are close with the start of your URL.  It should be https://servername/sites/reports/XXXX.   By the way are you sure it is https and not just http?

    So Reports is the name of the SharePoint site.  XXX is the name of the report library.  You might use your browser to browse to https://servername/sites/reports/ and then look for the library storing the reports.  Once there drill down on the library and look at your URL and then you should see something like the first URL above.  Try that one.


    My Ramblings @ http://alanwhitehouse.wordpress.com and My Tweets @ http://www.twitter.com/alanwhitehouse

    Wednesday, August 29, 2012 9:13 PM
  • Hello Bill,

    The URLs that you specify for the report server and report are not quite the same. Here's a snippet from Create a Reporting Services report by using Dashboard Designer:

    In the Report Server URL box, specify the Web site address (URL) for the server that hosts the report that you want to use. Depending on how Reporting Services is configured, the URL should resemble one of the following examples:

    • If Reporting Services is configured to use Windows authentication, then the server name typically takes the form http://servername/_vti_bin/reportserver.

    In the Report URL box, specify the complete address for the report that you want to use.

    The report address typically takes the form <a href="http:///<document">http://<servername>/<document library>/<reportname>.rdl.

     

    Hope this helps!

    Denise Stendera

    Wednesday, August 29, 2012 10:06 PM
  • Wow, you are running into all sorts of issues. Sorry to hear this.

    It appears that the URL is incorrect, at least the one that is displayed.  If you compare it to the one you pasted in Dashboard Designer is it the same? It appears there is a duplicate '/sites/Reports_XXXX/' section in the URL that is being displayed.

    Just an FYI, I believe it was the August 2011 CU for SharePoint that removed the SharePoint Report Server URL section, that is what is causing all the confusion. You are correct that you just need the path to the RDL file in SharePoint and you can get that by browsing for the report through the ReportServer location and copying and pasting that URL like you probably ended up doing.

    What SharePoint and SQL Server (assuming 2008 R2) build numbers are you on?

    I did find someone else having the same issue and just wondering what builds you are on to determine if another CU or SP would fix the issue.

    Reporting Services (rsItemNotFound) Dashboard Designer Preview "Error"

    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/3cfa07c7-590c-4717-b923-0c251d02f46b/


    Dan English's BI Blog


    • Edited by Dan English Thursday, August 30, 2012 7:21 PM typo with CU year
    • Marked as answer by Xue-Mei Chang-MSFT Friday, September 7, 2012 8:27 AM
    Thursday, August 30, 2012 7:20 PM

All replies

  • Do you have SSRS running in standard or SharePoint Integrated mode?  You mention "intergrated SSRS reports" above, but from the dropdown for "Server Mode" you have "Report Center" selected.

    Alan


    My Ramblings @ http://alanwhitehouse.wordpress.com and My Tweets @ http://www.twitter.com/alanwhitehouse

    Wednesday, August 29, 2012 8:14 PM
  • When I try to copy and paste the Report URL in Integrated Mode, I get an error message saying "Unable to connect to server."

    I am not sure what I am doing wrong.  If you can, could you run me through the correct process for adding a Report?  I can't seem to find an article for this.  Thank you so much.

    Wednesday, August 29, 2012 8:24 PM
  • 1.  Do you know if you are running in SharePoint Integrated or SSRS traditional mode?

    2.  Can you access and run the report outside of PerformancePoint Services?

    3.  If yes to #2, how are you accessing it.  It will help answer the question to #1.

    In the picture below, I am running in traditional mode.  I selected Report Center and then the path that SSRS is running under.  When I browse for reports I should see the popup windows shown.


    My Ramblings @ http://alanwhitehouse.wordpress.com and My Tweets @ http://www.twitter.com/alanwhitehouse

    Wednesday, August 29, 2012 8:36 PM
  • I am almost positive it is in Integrated mode, as it appears to be a normal sharepoint site.  It is on our reports server, different from the one I am using PerformancePoint on.  And yes, the report runs just fine on the report server.  We have many reports out there.  I don't know where to look in central admin to see if it is or not, however.  I did not configure the SSRS site.  I do know that PerformancePoint services is running on the Reports server as well as the site where I am configuring the dashboard.  Not sure if that matters.

    Thanks again.

    Wednesday, August 29, 2012 8:45 PM
  • So if it is integrated mode. Then your dropdown for Server Mode in the Report Setup section of PPS needs to be Integrated Mode, not Report Center like your screenshot shows.  Have you tried that?


    My Ramblings @ http://alanwhitehouse.wordpress.com and My Tweets @ http://www.twitter.com/alanwhitehouse

    Wednesday, August 29, 2012 8:54 PM
  • I've tried it both ways.

    When I try to copy and paste the Report URL in Integrated Mode, I get an error message saying "Unable to connect to server."

    Wednesday, August 29, 2012 8:56 PM
  • What URL are you using in Integrated Mode.  It will not be the same as in standard mode.  Basically it is the URL path to the document library in SharePoint holding the reports.

    My Ramblings @ http://alanwhitehouse.wordpress.com and My Tweets @ http://www.twitter.com/alanwhitehouse


    Wednesday, August 29, 2012 8:59 PM
  • I have been trying to copy the URL of the report from SSRS by first opening the report and then copying what's in the navigation bar in IE.  It's all garbled and has a bunch of gibberish.  I also tried just copying: https://servername.com/sites/Reports/_layouts/ReportServer/ as well as several other iterations of that just trying to get it to pick up the reports server.  No dice.

    Wednesday, August 29, 2012 9:04 PM
  • You are close with the start of your URL.  It should be https://servername/sites/reports/XXXX.   By the way are you sure it is https and not just http?

    So Reports is the name of the SharePoint site.  XXX is the name of the report library.  You might use your browser to browse to https://servername/sites/reports/ and then look for the library storing the reports.  Once there drill down on the library and look at your URL and then you should see something like the first URL above.  Try that one.


    My Ramblings @ http://alanwhitehouse.wordpress.com and My Tweets @ http://www.twitter.com/alanwhitehouse

    Wednesday, August 29, 2012 9:13 PM
  • Hello Bill,

    The URLs that you specify for the report server and report are not quite the same. Here's a snippet from Create a Reporting Services report by using Dashboard Designer:

    In the Report Server URL box, specify the Web site address (URL) for the server that hosts the report that you want to use. Depending on how Reporting Services is configured, the URL should resemble one of the following examples:

    • If Reporting Services is configured to use Windows authentication, then the server name typically takes the form http://servername/_vti_bin/reportserver.

    In the Report URL box, specify the complete address for the report that you want to use.

    The report address typically takes the form <a href="http:///<document">http://<servername>/<document library>/<reportname>.rdl.

     

    Hope this helps!

    Denise Stendera

    Wednesday, August 29, 2012 10:06 PM
  • Alan,

    I followed your instructions above:

    " You might use your browser to browse tohttps://servername/sites/reports/ and then look for the library storing the reports.  Once there drill down on the library and look at your URL and then you should see something like the first URL above.  Try that one."

    But, I am now getting the following error:


    Thursday, August 30, 2012 2:10 PM
  • Try it without the "/Forms/AllItems.aspx".

    My Ramblings @ http://alanwhitehouse.wordpress.com and My Tweets @ http://www.twitter.com/alanwhitehouse

    Thursday, August 30, 2012 3:01 PM
  • Alan,

    I am finally able to get an SSRS page to show up, however it is giving me an rsItemNotFound now.

    Image: http://social.msdn.microsoft.com/Forums/getfile/159565

    Thursday, August 30, 2012 3:55 PM
  • Wow, you are running into all sorts of issues. Sorry to hear this.

    It appears that the URL is incorrect, at least the one that is displayed.  If you compare it to the one you pasted in Dashboard Designer is it the same? It appears there is a duplicate '/sites/Reports_XXXX/' section in the URL that is being displayed.

    Just an FYI, I believe it was the August 2011 CU for SharePoint that removed the SharePoint Report Server URL section, that is what is causing all the confusion. You are correct that you just need the path to the RDL file in SharePoint and you can get that by browsing for the report through the ReportServer location and copying and pasting that URL like you probably ended up doing.

    What SharePoint and SQL Server (assuming 2008 R2) build numbers are you on?

    I did find someone else having the same issue and just wondering what builds you are on to determine if another CU or SP would fix the issue.

    Reporting Services (rsItemNotFound) Dashboard Designer Preview "Error"

    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/3cfa07c7-590c-4717-b923-0c251d02f46b/


    Dan English's BI Blog


    • Edited by Dan English Thursday, August 30, 2012 7:21 PM typo with CU year
    • Marked as answer by Xue-Mei Chang-MSFT Friday, September 7, 2012 8:27 AM
    Thursday, August 30, 2012 7:20 PM