Report Builder 2.0 - Create a Bookmark

Create a bookmark and jump to it

Bookmarks are also like hyperlinks in web pages but they jump to another part in the same document. Microsoft Word supports adding bookmarks to several locations in the document and makes a provision to jump to them. In web pages, the same is achieved by having links and anchors (Link). In this section you will create a bookmark for the title of Second Column. This way when you click on the Second series on the chart, the display changes to the second column title.

Create a bookmark using the Bookmark property

You need to create a bookmark first:

1. Click View and place a check mark in the Properties checkbox. This allows you to access the Properties window for all objects in the report. right-clicking on an object shows only a limited number of available properties.

2. In the design view of the report click on the Second column title.

3. In its Properties window type in the text Go to data for its Bookmark property. This is shown in the following screenshot:

Jump to bookmark using the Action property

There are basically two steps in order to have the ability to jump to a known location. The first step is to create a bookmark and the next step is jump to it. Different parts of the report builder are used and this section shows how you may do it.

1. In the design view of the chart, click on the series Second_ as shown and set its Action property to Go to Data as shown:

2. Run the report from Home | Run.

3. Verify that only the series Second_ in the chart takes you to the top of the report.

Summary

The Report Builder 2.0 tool is described in full starting from the top to the bottom of this interface. Creating reports with this tool is described using an existing report and modifying it as well as creating a new report from data. Embedding charts and gauges are also described. Some of the interactive and rich text features are also discussed.

Report Builder 1.0 is briefly mentioned but its utility for reports models created using VS 2008 or BIDS did not warrant an example due to current limitations. It may be possible to use this tool with Report Models created with an earlier version of SQL Server. One of the main features of Report Builder 2.0 is its ability to create Ad Hoc reports and this will be described in detail in the next chapter. The reader may notice slight differences in the look of the interfaces slightly at variance depending on the version of the SQL Server 2008 and Report Builder 2.0 used.

Where to buy this book

You can buy Learning SQL Server 2008 Reporting Services from the Packt Publishing website

Free shipping to the US, UK, Europe and selected Asian countries. For more information, please read our shipping policy.

Alternatively, you can buy the book from Amazon, BN.com, Computer Manuals and most internet book retailers.