Step 8 - Insert Hyperlinks to other Reports

The last two fields in the Other Fields section are new fields. They are Report to Hyperlink To and Field To Hyperlink From. These two fields give the ability of linking one report to another. It in effect, this allows the user to hyperlink (or drill down) from one report to another – typically from a summary type report to one that contains more/different information. For example, an Absence Summary report can be created where each employee's absences are summarized onto a single line. The report can be created indicating that it should hyperlink from the Absence Hours field on this summary report to an Absence Detail report that shows all of the absences that make up the absence amount on the summary report.

Continuing with this example, the name of the Absence Detail Report would be specified in the "Report to Hyperlink To" field, and then enter the Absence Hours field in the "Field To Hyperlink From" field. Once this is done, a special Hyperlink Information screen will occur where prompts for the "Field To Hyperlink With" will appear. This field will have a drop down box of all selection fields of the hyperlinked report. In our case, we will select the Employee No field. This will cause the employee number from our summary report to be passed through to our detail report so that it can display the correct employee's information.

See Appendix B for screen shot examples of the Hyperlink Feature.