Lesson 3: Verifying Your Clickthrough Report Changes

SQL Server 2008 R2

In this lesson, you will verify that the customized clickthrough report that you created in Lesson 1 appears when you click a Product entity field that contains an aggregate value.


SQL Server 2008 R2 Reporting Services includes both Report Builder 1.0 and Report Builder 3.0.


Report Builder 1.0 includes a built-in option to use a report as a clickthrough report. In Report Builder 3.0, you manually create the clickthrough link that makes the report a clickthrough report. Alternatively, you can create the basic report in Report Builder 1.0, set the clickthrough option, and then open and enhance the report with SQL Server 2008 R2 Reporting Services features in Report Builder 3.0. This tutorial does not include a procedure for creating manual clickthrough links.

To open Report Builder 1.0

  1. Start Microsoft Internet Explorer, beginning with Internet Explorer 6.

  2. In the Address bar of the Web browser, type the Report Manager URL.

    By default, this is http://<ComputerName>/reports.

  3. On the Home page of Report Manager, click Report Builder.

    The Report Builder window opens.

    Important noteImportant

    In SQL Server 2008 R2, Report Builder 3.0 is the default version of Report Builder. To open Report Builder 1.0, use the URL: http://<servername>/reportserver/reportbuilder/reportbuilder.application.

  4. In the Getting Started pane, select AdventureWorks2008R2 and then click OK.

    Next, you will start to create a basic Report Builder report that contains the Product Category, Product Subcategory and Product name fields.

To create a Report Builder 1.0 report

  1. In the Entities list, select Product.

  2. In the Fields list, double-click Product Category.

    A Product Category group is added to the design area.

  3. In the Fields list, double-click #Products.

  4. On the View menu, click Run Report.

    A two column report is displayed.

To verify the clickthrough report changes

  1. Next to the Clothing category, in the #Products column, click 35.

    Thirty-five is the number of clothing products. The customized clickthrough report that you created in Lesson 1 is displayed.

  2. On the toolbar, click Back to parent report.

You have verified that your customized clickthrough report appears as expected and you have successfully completed this tutorial.

Community Additions