By default, the report server generates two clickthrough template types for each entity: a single instance template and a multiple instance template. The item that you click on determines which template is used. If the person reading the report clicks a scalar attribute, the single instance template is used. If the person reading the report clicks an aggregate attribute, the multiple instance template is used.

Single Instance Templates

A single instance template displays all the attributes of the target entity and all the default aggregate attributes that are specified for the related entities that have a one-to-many relationship from the target entity. A single instance template looks similar to the following image.

Multiple Instance Templates

A multiple instance template displays only the default detail attributes of the target entity and all of the default aggregate attributes that are specified for the related entities that have a one-to-many relationship from the target entity. A multiple instance template looks similar to the following image.

Instead of using the default templates that the report server generates, you can create a report in Report Builder and use it as a customized clickthrough report. Then, you can link your report to the model as a drillthrough report in Report Manager.

To turn a Report Builder report into a clickthrough report, you need to select the Enable Drillthrough to this Report option in the Report Builder Properties dialog box. Once this option is selected, a drillthrough parameter is added to the report and the report can no longer be run in Report Builder directly. The drillthrough parameter is automatically calculated by the report server when the report reader clicks on an item in a Report Builder report. For more information on how to create your own report and use it as a customized clickthrough report, see Tutorial: Customizing Report Builder Clickthrough Reports.

Important:
The primary, or base, entity used in the report must be the same entity that you link the report to.

Concepts

Other Resources

Help and Information