Search results
PDF

Bookmark

Bookmark links allows the users to navigate to different parts of the RDL report. You can add bookmarks to each textbox, image, table or chart or to the unique group values displayed in a tablix which can direct the users to specified locations in the report. The value of bookmark property can be your own strings or an expression.

Configure bookmark

  1. Select the text box, image, table, chart, or other report item to which you want to add a bookmark. The respective report item properties will be listed in the Properties pane.
  2. Under Miscellaneous category, enter a string or expression in Bookmark text field. It will act as the label for this bookmark. Configure Bookmark

Refer Set Expressions and Reset Expressions section to open set/reset expression menu in properties panel.

Set Expression

Note: 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.

  1. Select the text box, image, or chart series to which you want to link a bookmark. The respective item properties will be listed in the Properties pane.
  2. Under Link category, choose Bookmark option. An option to link the bookmark will be enabled. Choose Bookmark
  3. In the bookmark dropdown, type or select a bookmark or set an expression that evaluates to a bookmark. Choose value

Designing bookmark report

The following example will show how to use a bookmark feature to design an interactive report.

Create data

In this designing section, the following dataset query is used for dataset creation.

SELECT [HumanResources].[vEmployee].[EmployeeID],
[HumanResources].[vEmployee].[FirstName],
[HumanResources].[vEmployee].[LastName],
[HumanResources].[vEmployee].[EmailAddress],
[HumanResources].[vEmployee].[City],
[HumanResources].[vEmployee].[CountryRegionName]
FROM [HumanResources].[vEmployee]

Refer Create Data section and create dataset using the above query. AdventuresWorks database is used here.

Add bookmark

This design will teach you how to configure and link the book marks in report items. At runtime, clicking on the items will navigate to the first matching bookmarks.

Add a textbox to the report and enter the text as Home Page. Apply some formatting. Add textbox

Open the textbox properties. Under Miscellaneous category, enter the Bookmark property value as HomePage. Add textbox

Add a matrix report item and remove the first column. Add matrix cell

Assign CountryRegionName field in the first cell. Add matrix cell

Select that cell and open properties panel. Under Link category, choose Bookmark option.

Choose bookmark

Set the =Fields!CountryRegionName.Value expression in Bookmark field.

Link bookmark in matrix cell

Add a rectangle and set the Page Break as Start.

Link bookmark in matrix cell

Then insert a table report item. Refer Add table section to add table.

Add table

Assign dataset fields and apply formatting as shown in below image.

Table design

Open CountryRegionName group properties and set the page break as End.

Table design

Select the CountryRegionName group cell and open properties panel. Under Miscellaneous category, enter the Bookmark property value as =Fields!CountryRegionName.Value.

Table design

Add a column in table report item.

Table design

Now, we are going to add an image in table cell and configure book mark to it. When clicking on the image, it will navigate to the first page of the report.

Insert an image in first cell of the column.

Table design

Select the image and open properties panel. Under Link category, choose Bookmark option.

Choose bookmark

Choose the HomePage bookmark label in Bookmark option.

Table design

Set the border as None for the first column cell.

Table design

To repeat header row for each group, enable Report on New Page and set Keep With Group as After for first static field.

Table design

Preview

On report preview, first page of the report looks like below,

Preview First Page

Clicking on a country name will display respective group.

Select group

Preview design

Clicking on the image will navigate to the main page of the report.

Preview design

Preview First Page

Download the above report design from the link