Linked Reports

The ability to create drilldowns can be added by linking reports. Linked reports are only available in the Report Viewer or Dashboard Viewer.

The Linked Report menu contains three tabs: Report, Fields, and Formula.

Report

The Report tab allows you to select which report to link to.

When a link is set on a cell, the unique key of the information being displayed is used to automatically filter the linked report. In the example below, the linked report is filtered for information where Employee Last Name equals ‘Buchanan.’ Note that report and dashboard filters also affect the data within drilldowns.

Fields

By default, this application will attempt to map the field contents of the linked cell to the same field in the linked report. (E.g. {Categories.CategoryID} <> {Categories.CategoryID}).

Using the Fields tab, you can specify which fields to link in order to map different fields with similar content. (E.g. {Categories.CategoryID} <> {Products.CategoryID}).

To add a custom link:

To remove a custom link, press the 'Delete' () button.

Formula

The Formula tab allows you to specify a custom formula in order to further filter the data passed from the linked report. The formula must return True or False. The formula is evaluated for each row in the parent report, and if the condition is not met, the data is excluded from the linked report. See Formulas for more information.

NOTE. Formulas only support one data field. If multiple data fields are used, all but the first will be ignored.

Chart Drilldowns

Chart drilldowns can also be created by using the Linked Reports menu. Chart drilldowns are only available in the Report Viewer or Dashboard Viewer.