CHAPTER 6 BUILDING REPORTSFigure 6-15. Tablix Properties
Adding a Bookmark Link
In this section, you will add a bookmark link to the Employee Name field in the Employee Listing report
that, when clicked, will jump to a defined location within the report. In this case, you will not add
another Table data region to the report to contain detail information about employee visits. Bookmarks
ease the navigation burden on large reports when users are looking for specific information. As
discussed previously, summary and detail information can exist within the same report; in the case of
adding a bookmark, you are not hiding the data so much as moving it to another location within the
same report. The net effect for the user is the same, however, in that they control when they see the
detail information.
To add a bookmark to the Employee Listing report, first follow the procedure to drag a new table
element to the Design tab. Next, drag the patLastName over into the first column of the table. Right click
it and choose Expression. Write an expression similar to the one you did for the Employee Name column
earlier, but utilize the patLastName and patFirstName columns. Rename the header Patient Name. Now,
for this table, you will want to group by the employee name, so right-click your detail row and select Add
Group and then select Parent Group. You will use the same trimmed expression as the group value
expression, as follows:
=RTRIM(Fields!LastName.Value) & ", " & RTRIM(Fields!FirstName.Value)
Change the name of the group to Employee_Name. Then, on the Page Break tab, select the option to
enable a break Between each instance of a group. This will force the detail line for each employee to start
on a new page. Next, add the date field that represents when the service was performed,
=Fields!ChargeServiceStartDate.Value, to the third column, and format the date as you did earlier using
the MM/dd/yyyy style.
Now when you preview the report, the summary employee listing will appear on the first page, and
the detail records that show the employee visits will appear on each subsequent page.
Next, you will add a Bookmark property value to the Employee_Name field in the detail row of the
second table. In SSRS 2012, you will need to add the Bookmark to a field using the Properties window.
With the Properties window visible, click the Employee Name field in the details row, shown in Figure 6-
- In the Properties window, enter your trimmed employee name expression into the bookmark value
box. This will serve as the pointer record for the bookmark link you will now create.