Thursday, December 13, 2018

SSRS - How to Add Bookmarks Actions in Report

SSRS bookmarks are essentially customized navigational links in the report. 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.
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.



In this tutorial, we are going to learn how to Add bookmarks and bookmark links to a report. 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. We can create your own strings to use as bookmarks, or, for groups, you can set the bookmark to the group expression.

To add a bookmark link - 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. For example, you could type BikePhoto as the bookmark for an image in your report.
  1. In Design view, right-click the text box, image, chart, to which you want to add a link and then click Properties.
  2. In The Properties dialog box for that report item, click Action.
  3. Select Go to bookmark. An additional section appears in the dialog box for this option.
  4. 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.
  5. Click OK.
  6. (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.
  7. To test the link, click Run to preview the report, and then click the report item that you set this link on

Popular Posts

Get Sponsored by Big Brands