Share via


Lesson 3: Verifying Your Clickthrough Report Changes

New: 14 April 2006

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.

To open Report Builder

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

  4. In the Getting Started pane, select Adventure Works 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 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.

Next Steps

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

See Also

Other Resources

Working with Clickthrough Reports
How to: Link a Report to a Model as a Clickthrough Report

Help and Information

Getting SQL Server 2005 Assistance