Add a Hyperlink to a URL (Report Builder and SSRS)
Updated: September 7, 2016
Applies To: SQL Server 2016
Learn how to add hyperlink actions to text boxes, images, charts, and gauges in Reporting Services paginated reports. Links can go to other reports, to bookmarks in a report, or to static or dynamic URLs.
You can add a hyperlink action to any item that has an Action property, for example, a text box, an image, or a calculated series in a chart. When the user clicks that report item, the action that you define takes place.
You can add a hyperlink that will open a browser with a URL that you specify. The hyperlink can be a static URL or an expression that evaluates to a URL. If you have a field in a database that contains URLs, the expression can contain that field, resulting in a dynamic list of hyperlinks in the report. Make sure your report readers have access to the URL that you provide.
You can also specify URLs to create drillthroughs to reports on any report server that you and your users have permission to view using URL requests to the report server. For example, you can specify a report and hide the document map for the user when they first view the report. For more information, see URL Access (SSRS) and Specifying Paths to External Items (Report Builder and SSRS).
And you can add a bookmark to a specific place in the same report.
Try adding hyperlinks with sample data in Tutorial: Format Text (Report Builder).
In report design view, right-click the text box, image, or chart to which you want to add a link and then click Properties.
In the Properties dialog box, click the Action tab. Read on for information about your options.
On the Action tab, select Go to report.
Specify the target report and parameters you want to use. The parameter names must match the parameters defined for the target report.
Use the Add and Delete buttons to add and remove parameters, and the up and down arrows to order the list of parameters.
Type or select a Value to pass for the named parameter in the drillthrough report. Click the Expression (fx) button to edit the expression.
Select Omit to prevent the parameter from running. By default, this check box is cleared and not active. To select the check box, click the Expression (fx) button and either type True or create an expression. The check box is selected when you click OK in the Expression dialog box.
See Add a Drillthrough Action on a Report for more information.
You can link to bookmarks to a location in the current report. To link to a bookmark, you must first set the Bookmark property of a report item. To set the Bookmark property, select a report item, and in the Properties pane, type a value or expression for the bookmark ID; for example, SalesChart or 5TopSales.
On the Action tab, select Go to bookmark.
Type or select the bookmark ID for the report to jump to. Click the Expression (fx) button to change the expression.
The bookmark ID can be either a static ID or an expression that evaluates to a bookmark ID. The expression can include a field that contains a bookmark ID.
See Add a Bookmark to a Report for more information.
On the Action tab, select Go to URL. An additional section appears in the dialog box for this option.
In Select URL, type or select a URL or an expression that evaluates to a URL, or click the drop-down arrow and click the name of a field that contains a URL.
For an item published to a report server configured for native mode, use a full or relative path. For example,
For an item published to a report server configured in SharePoint integrated mode, use a fully qualified URL. For example,
(Optional) The text is not automatically formatted as a link. For text, it is helpful to change the color and effect of the text to indicate that the text is a link. For example, change the color to blue and the effect to underline in the Font section in the Home tab of the Ribbon.
To test the link, click Run to preview the report, and then click the report item that you set this link on.