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.

To open SQL Server 2005 Management Studio

1. 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.

2. In the Server type drop-down list, select Reporting Services.

3. In the Server name drop-down list, select the name of the report server to which you want to connect.

4. In the Authentication drop-down list, select Windows Authentication.

5. Click Connect.

   The Microsoft SQL Server Management Studio window opens.

To create a customized clickthrough report

1. In Object Explorer, expand the Home node.

2. Locate the model that you want to link the report to.

3. Double-click the model.

   The Model Properties dialog box opens.

4. In the Select a page area, select Drill-through reports.

5. In the Select the model item for which to set drill-through reports pane, select the entity that you want to use.

6. 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.

7. In the Select item dialog box, select the report and then click OK.

8. 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

Help and Information

Getting SQL Server 2005 Assistance