SSRS: Bookmarks

SSRS bookmarks are 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.

You can create only a link inside your report. If you need a link to another report use> Action > Go to report

Demo:

I want to create a Master report (Report 1 on the picture) with two years > text boxes. When you click on one of these text boxes, you'll be transferred into a report containing more data for the particular year. (Report 2 for year 2018)

insert the tables
add page breaks
add bookmarks

Step 1

Data source: sample data

Dataset:

SELECT Year([OrderDate]) orderyear

,[Region]

,[Representant]

,[Category]

,[Item]

,[Units]

,[UnitCost]

FROM [Test].[dbo].[salesCat]

Step 2

Create two reports to display the details by year.

In the Master report I have 2 text boxes with years 2018 and 2019. If I click on 2018 I'll be linked to the report WHERE YEAR([OrderDate]) = 2018..

Step 3

Create 3 dataset and insert 3 tables.

In the following steps, I will have to insert a page breaks and then define the bookmarks

Step 4

I need a page break after the first table. Right click on the table > Tablix Properties...

Add a page break after.

Step 5

For the second table Sales2018, add a page break after.

Sales2019 doesn't need any page break.

Step 6

Now we need to define the bookmarks and it is done.

Create a bookmark for the first table. The tables are divided by the page breaks so it really doesn't matter on which element the bookmark will be created.

Click on the text box, press F4 for properties > Other: write something in the field. [master]