CHAPTER 6 BUILDING REPORTSAdding Hyperlink Formatting and Tooltips
Before you save the new Employee Listing report with added links, let’s add two formatting properties
that will make the link more obvious as well as provide feedback on what will happen when the link is
selected. The first task is simply to make the EmployeeID field resemble a hyperlink. Select the field, and
apply an underline and color format of blue (see Figure 6-24).
Figure 6-24. Employee Listing report with visible hyperlinks
Next you will add a tooltip to the same field. Tooltips appear whenever a user hover’s the cursor
over the field, and they provide additional information. In this case, you will use one simply to show
which report will be called when the EmployeeID box is clicked—the Patient Survey Letter report. The
ToolTip property is located on the General tab of the Textbox Properties window. After selecting the
field, open the Properties box, and enter Patient Survey Letter as the tooltip. Notice that the tooltip, like
most other values, can be an expression as well as a literal string.
It is possible to assign multiple parameter selections, dataset fields, expressions, and fixed literals as
input for the drill-through report. Now that you have linked to a report that could potentially have
multiple parameters, let’s take a closer look at how parameters and filters work together to deliver data
to a report.