Add a Bookmarks to a report in SSRS

This article demonstrate how to add a bookmarks to a report in SSRS.

Bookmark allows us to to navigate from one part of report to different parts of a report, or you can say it provides navigation links within a report.

Lets see the implementation of Bookmarks step by step.

As you can see, we have two Multi group drill down reports as shown below, first report displays the details of customer’s who have got Bachelor degree and second report displays the details of customer’s who have got Graduate degree.

Note : you can take any simple report/ tabular report for demo, not necessary to have Multi group drill down report.

 

Lets see the output of report in preview tab.

Preview of first report:

Preview of second report:

As both reports are displaying on single page, lets display both report separately and call them based on user request.

Basically, the idea is that report will have two tab and clicking on individual tab user will be navigated to requested report.

The Tab is nothing but a simple textbox which is formatted in such a way that make it looks like a button, and when user clicks on tab is navigated to requested report based on bookmark specified to tab.

Lets create a tab first, for this Right click on report body then navigate to Insert and select Text Box from context menu.

Now give a name to text box View Bachelors, and set background color and font size from property window. To open property window select text box then press F4.

Now create one more text box, for this just copy and paste previously created text box and name it as Graduate Degree.

 After that, Right click on first report’s Tablix and select Tablix Properties.. from context menu.

You will see, a Tablix Properties window opens, In General tab, go to Page break options and check Add a page break after then click on OK button.

Now once you done with this, you will see each report is displayed on separate page.

On Page 1, first report is displayed while second report is displayed on Page 2 as shown below.

Now will add a bookmark for each report Tablix, then call each bookmark through Tab.

Select first report’s Tablix and then add bookmark in property window (Press F4 ).

In Property window go to Other property then give name to Bookmark as ReportBachelors.

Now repeat the same step and add a bookmark for second report as well.

Select second report’s Tablix and then add bookmark in property window (Press F4).

In Property window go to Other property then give name to Bookmark as ReportGraduateDegree.

Once you done with this, just copy both textbox View Bachelors and Graduate Degree and paste just right above second report as shown below.

Now time to set an action on textbox. When user will click on View Bachelors textbox, or can call it tab, user will be navigated to first report which display the data of customer who holds Bachelor, and when user will click on Graduate Degree textbox, or tab then user will be navigated to second report which display the data of customer who holds Graduate Degree.

Right click on First text box View Bachelors then select Text box properties..

Once you select Text box properties.. a Text Box Properties window opens.

Go to Action tab, select Go to bookmark, and specified a bookmark ReportBachelors that you created for View Bachelors report (first report) as we want to navigate user to first report when user click on View Bachelors box.

After that click on OK button.

Then select second text box Graduate Degree then select Text box properties..

Now this time specified a second report bookmark that is ReportGraduateDegree as we want to navigate user to second report when user click on Graduate Degree box then click on OK button.

Follow the same steps and specified the same bookmarks for second pair of textboxes.

Once you done with this, just go to preview tab and see the final output.

And you can see, By default it displays the first report View Bachelors on first page.

Lets click on Second tab that is Graduate Degree,  and you can see, it navigates to second report which display the data of customer’s who hold Graduate degree.

Lets click on View Bachelors tab on second page, and you can see it navigates you to first report which display the data of customer’s who holds the Bachelors degree.

So far we have implemented bookmarks successfully, and you can see it allows us to navigate on requested report.

Lets make tab button more real by formatting it, so that you can easily see which button is pressed.

Now for first report, we will set a border for text box Graduate Degree.  Select text box then right click and select Text Box Properties.. from context menu.

Now a Text Box Properties window opens, in Border tab, set border as shown below.

Then click on OK button.

Now will set border for View Bachelors tab for second report, just select text box then right click and select Text Box Properties..

Now a Text Box Properties window opens, in Border tab, set border as shown below.

Then click on OK button.

Now once you done with this,  you will see for Bachelors report a View Bachelors tab looks like a pressed button, means you are viewing a Bachelors report.

While on Graduate report a Graduate Degree tab looks like a pressed button.

Lets see the report preview, now you can see the effect of formatting.

Now tab looks more real and you can easily see which one is pressed.

 

Also Read…

Create a Drill Down Group Report in SSRS

Create Multi Group Drill Down report in SSRS

Create a DrillThrough report in SSRS

 

 3,928 total views,  1 views today