Results 1 to 1 of 1
  1. #1
    Join Date
    Jun 2011

    Unanswered: Accessing a Report Server Url when SSRS is configured for SharePoint Integrated mode

    We have a requirement in our project to access the Report from Report Server Url and Reporting Services is configured for SharePoint Integrated mode. In our requirement We have to build a custom Webpart in sharepoint 2010 to display the Report that uses Report Viewer.
    We are facing a problem in accessing the Report Server Url and binding the SSRS Report to Asp.Net Report Viewer.
    We build report in SSRS 2008 and deployed in below url that is SSRS-Sharepoint integrated mode.
    Here TabTest is a site and Reports is ReportLibrary in sharepoint.
    We are trying to access Report from user control .Below is the code we are using.
    Page_Load of User control
    ReportViewer1.ProcessingMode = ProcessingMode.Remote;
    ReportViewer1.ServerReport.ReportServerUrl = new Uri("http://server5:99/");
    ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerCredentials("xxx", "xxx", "xxx");
    ReportViewer1.ServerReport.ReportPath = "/ TabTest/Reports/EPHT_AsthamaRep.rdl";
    We get error message saying
    “The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.
    Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <html> <head> <title>The file you are attempting to save or retrieve has been blocked from this Web site by the server administrators.

    We tried in google but nothing helped. We are new to Sharepoint 2010 and SSRS 2008. Could anyone help us on this?
    Attached Thumbnails Attached Thumbnails ssrs_error.png   SSRS_Error1.png  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts