Share via


Lesson 2: Linking the Report to the Report Model

New: 14 April 2006

After you have created and published your customized clickthrough report, you must link it to the entity for which it will appear. In SQL Server Management Studio, your report can be linked to the entity as a single instance or a multiple instance clickthrough report. If this report is used as the single instance clickthrough report, the report is displayed when the person reading the report clicks on a single instance of the entity. If this report is used as the multiple instance clickthrough report, the report is displayed when the person reading the report clicks on an aggregate value for that entity.

In this lesson, you will link the report that you created in Lesson 1 as a multiple instance to the Product entity in Management Studio.

To open SQL Server 2005 Management Studio

  1. Click Start, point to All Programs, point to Microsoft 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. Next, you will link the report to the entity in the report model.

  1. In Object Explorer, expand the Home node.

  2. Locate the Adventure Works model.

  3. Double-click the Adventure Works 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 Product entity.

    Note

    The entity that you select here must be the same entity as the primary entity of the report that you created and modified in Lesson 1. For this tutorial, that is the Product entity.

  6. Click the Multiple instance ellipsis (…) button.

    Because you want this customized report to appear when the person viewing the report clicks on an aggregate value in the Product entity, you must select Multiple instance. If you wanted the report to appear when the person viewing the report clicks a scalar value, such as the product name, you would select Single instance.

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

  8. Click OK again.

Next Steps

You have successfully linked a customized clickthrough report to your model. In the next lesson, you will verify that the clickthrough report appears when expected. See Lesson 3: Verifying Your Clickthrough Report Changes.

See Also

Concepts

Tutorial: Customizing Report Builder Clickthrough Reports

Other Resources

Introducing SQL Server Management Studio

Help and Information

Getting SQL Server 2005 Assistance