Database Reference
In-Depth Information
How it works...
A drillthrough report is a report that is opened by clicking on a link within another report.
Drillthrough reports commonly have additional details about an item that is in an original
summary report. The data in the drillthrough report is not retrieved until the user clicks on
the link in the main report that opens the drillthrough report. If the data for the main report
and the drillthrough report must be retrieved at the same time, consider using a subreport
instead by following the procedures in the previous recipe.
A drillthrough typically contains parameters that are passed to it by the summary report.
The recipe also makes use of formatting to show the report consumer that this is a drill-
through report. This is achieved by underlining and changing the font color to blue (the res-
ult is similar to how a web link looks).
