Wednesday, May 7, 2014

SSRS 2008 R2 Reports in IE, Chrome, Firefox, and Opera

We added the following JS to the SSRS Server Microsoft SQL Server\MSRS**.MSSQLSERVER\Reporting Services\ReportManager\js\ReportingServices.js" .


function pageLoad()
{   
    var element = document.getElementById("ctl31_ctl10");

    if (element)
    {
        element.style.overflow = "visible";
    }

    var element2 = document.getElementById("ctl32_ctl09");

    if (element2)
    {
        element2.style.overflow = "visible";
    }

}

Be sure to clear the cache in your browser before rerunning the report.

http://stackoverflow.com/questions/5428017/cannot-view-ssrs-2008-r2-ssrs-2012-reports-in-safari-chrome-but-works-fine-in

Thanks for your post Emanuele Greco

Tuesday, April 29, 2014

Visual Studio 2012 report server could not be found error

  • Open the Reporting Services Configuration manager by going to All Programs> Microsoft SQL Server 2012> Configuration Tools> Reporting Services Configuration Manager
  • On the left hand side select Web Service URL
  • In the Report Server Web Service Virtual Directory select Advanced
  • In the Multiple HTTP Identities for the Report Server Web Service select Add
  • Select the Host Header Name radio button and add the name of your server and click OK
  • In Visual Studio 2012 make sure the Target Server URL matches the URL in the Report Server Web Service URLs section http://YOURSERVER/ReportServer