How to: Link a Report to a Model as a Clickthrough Report
New: 5 December 2005
Instead of using the default clickthrough report templates, you can create a Report Builder report and then link it to a specific entity in the report model. When the person viewing the report clicks the interactive data in the main report, this report is displayed as a clickthrough report. To link a report to an entity, use the SQL Server 2005 Management Studio.
Important
The primary, or base, entity that is used in the report must to be the same entity to which the report is linked.
To open SQL Server 2005 Management Studio
Click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.
The Connect to Server dialog box opens.
In the Server type drop-down list, select Reporting Services.
In the Server name drop-down list, select the name of the report server to which you want to connect.
In the Authentication drop-down list, select Windows Authentication.
Click Connect.
The Microsoft SQL Server Management Studio window opens.
To create a customized clickthrough report
In Object Explorer, expand the Home node.
Locate the model that you want to link the report to.
Double-click the model.
The Model Properties dialog box opens.
In the Select a page area, select Drill-through reports.
In the Select the model item for which to set drill-through reports pane, select the entity that you want to use.
To display this report when the person reading the report clicks a scalar attribute for this entity, click the Single instance ellipsis (…) button.
-or-
To display this report when the person reading the report clicks an aggregate attribute for this entity, click the Multiple instance ellipsis (…) button.
In the Select item dialog box, select the report and then click OK.
Click OK.
See Also
Concepts
Working with Clickthrough Reports
Working with Models
Report Modeling How-to Topics
Report Builder How-to Topics
Other Resources
The SQL Server Management Studio Environment