How to use a URL to launch Report Builder 3.0 and edit a report

Make it easy for SharePoint site owners to edit their custom SSRS reports, by giving them a hyperlink that opens the Report Builder 3.0 application to a specific report.

This MSDN article and this Technet article show how the Report Builder application can be opened from a browser.

A native mode installation URL would be:

http://mycompany.org:8000/ReportServer/reportbuilder/reportbuilder_3_0_0_0.application 

… where “8000” would be the port you used when setting up the ReportServer service, while SSRS configured in SharePoint integration mode would take the form of:

http://mycompany.org/mysite/_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application

You might find it easier to open the application to a specific report by appending a “?” to the end of the latter URL followed by the report path. Replace spaces in the path after the question mark with plus signs, and skip the “rdl” file extension on the end. For example, to access a “Department Report.rdl” file in a library on a SharePoint site called “Reports Library,” the following URL should work (all in one line):

http://mycompany.org/mysite/_vti_bin/reportbuilder/ReportBuilder_3_0_0_0.application?http://mycompany.org/mysite/Reports+Library/Department+Report
References:

Advertisements

One thought on “How to use a URL to launch Report Builder 3.0 and edit a report

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s