Lesson 3: Verifying Your Clickthrough Report Changes
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
Start Microsoft Internet Explorer 6.
In the Address bar of the Web browser, type the Report Manager URL.
By default, this is http://<ComputerName>/reports.
On the Home page of Report Manager, click Report Builder.
The Report Builder window opens.
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
In the Entities list, select Product.
In the Fields list, double-click Product Category.
A Product Category group is added to the design area.
In the Fields list, double-click #Products.
On the View menu, click Run Report.
A two column report is displayed.
To verify the clickthrough report changes
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.
On the toolbar, click Back to parent report.