Add a Bookmark to a Report (Report Builder and SSRS)
Applies To: SQL Server 2016
Add bookmarks and bookmark links to a report when you want to provide a customized table of contents or to provide customized internal navigation links in the report. Typically, you add bookmarks to locations in the report to which you want to direct users, such as to each table or chart or to the unique group values displayed in a table or matrix. You can create your own strings to use as bookmarks, or, for groups, you can set the bookmark to the group expression.
After you create bookmarks, you can add report items that the user can click to go to each bookmark. These items are typically text boxes or images.
For example, if your report displays a table grouped by color, you would add a bookmark based on the group expression to the group header. Then you would add a table with a single text box at the beginning of the report that displayed the color values, and set the bookmark link on that text box. When you click the color, the report jumps to the page that displays the group header row for that color.
You can add a bookmark to any report item and add a bookmark link to any item that has an Action property, for example, a text box, an image, or a calculated series in a chart. For more information, see the Action Properties Dialog Box (Report Builder and SSRS).
In report design view, select the text box, image, chart, or other report item to which you want to add a bookmark. The properties for the selected item appear in the Properties pane.
In the text box next to Bookmark, type a string that is the label for this bookmark. For example, you could type BikePhoto as the bookmark for an image in your report. Alternatively, click the Expression (fx) button to open the Expression dialog box to specify an expression that evaluates to a label. For a group, the expression you type should be the group expression.
The bookmark can be any string, but it must be unique in the report. If the bookmark is not unique, a link to the bookmark finds the first matching bookmark.
In Design view, right-click the text box, image, chart, to which you want to add a link and then click Properties.
In The Properties dialog box for that report item, click Action.
Select Go to bookmark. An additional section appears in the dialog box for this option.
In the Select bookmark box, type or select a bookmark or an expression that evaluates to a bookmark. Using the previous example, type BikePhoto to create a link to the image in your report.
(Optional) The text is not automatically formatted like 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..