Edit In Report Builder Fails
Hey guys, I am able to get into the Reporting Services when I go to http://servername.domain/reports But when I click a report and try clicking "Edit in Report Builder" I get the standard IE "Internet Explorer cannot display the webpage" page. Any ideas how I can troubleshoot this? Or why is this happening?
September 14th, 2012 2:46pm

Hi Uchelp, Access to Report Builder depends on the following factors: Server properties that determine whether Report Builder is available on the report server. Role assignments or permissions that make Report Builder available to individual users or groups. Authentication settings that determine whether user credentials can be passed through to the report server or anonymous access is configured on application files. For more information about the Report Builder Access, please see: http://msdn.microsoft.com/en-us/library/ms365173(v=sql.100).aspx Whats more, if you want to edit reports in Report Builder, you can use the stand-alone version of Report Builder, and configure the Report Builder to connect to a report server by providing the URL to the target report server. The stand-alone version of Report Builder is not installed with Reporting Services. You can download and install it separately from the Microsoft Download Center. Regards, Fanny Liu Fanny Liu TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
September 17th, 2012 5:47am

Thanks for the reply Fanny, When I try to connect to the report server with the standalone version of Report Builder, I get this error: "Connection failed. Unable to connect to the server that is specified in the URL..etc." But I am able to connect to the report server when I use a browser and do everything but edit reports in Report Builder. So how is it a connection issue?
September 17th, 2012 11:43am

Does anyone else have any insight given my reply from yesterday ^ ??
Free Windows Admin Tool Kit Click here and download it now
September 18th, 2012 3:12pm

Solved this myself. It was a Microsoft issue. If you're using Windows 7 & IE9 like me, you must render the site in IE8 mode (F12 Developer Tools). After doing so, you can "Edit In Report Builder" and it will work. See this article for video help: http://chanmingman.wordpress.com/2011/06/25/to-use-report-builder-you-must-install-net-framework-3-5-on-this-computer/
September 18th, 2012 6:32pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics