Lesson 12: Specifying Clickthrough Report Options

Clickthrough reports comprise detailed information about the content displayed in the main report. If users want to see this additional information, they click the content displayed in the main report. A clickthrough report is automatically generated by the report server and displays the additional information.

There are two clickthrough templates for each entity: a single instance template and a multi-instance template. A single instance template is used when the user clicks an instance of the entity. A multi-instance template is used when the user clicks an aggregate value and multiple instances of the entity are displayed.

The fields displayed when the user clicks data and displays a clickthrough report are determined by settings in the Properties window. In this lesson, you will specify which fields are displayed when a user clicks content in the main report.

To specify clickthrough report options

  1. In the Tree view, select the Purchase Order Detail entity.

  2. In the Properties window, locate the DefaultDetailAttributes property, and then click the ellipsis () button.

    The AttributeReferenceCollection Editor dialog box appears.

  3. In the Members list, select the second Modified Date field, and then click Remove.

  4. Click Add.

    The Default Detail Attributes dialog box appears.

  5. In the Entities list, select Purchase Order.

  6. In the Fields list, select Purchase Order ID.

  7. To add the Purchase Order ID field as a detail field for the Purchase Order Details clickthrough report, click OK.

  8. Click Add.

  9. In the Entities list, select Purchase Order Detail.

  10. In the Fields list, select the Received Qty and Rejected Qty fields.


    You can press the CTRL key to select multiple noncontiguous fields.

  11. Click OK and then click OK again.

    Now, when the person viewing the Report Builder report clicks the value displayed in the Purchase Order Detail column, the Purchase Order ID, Received Qty and Rejected Qty fields are displayed in the resulting clickthrough report.

  12. On the File menu, click Save All.


You can customize clickthrough reports by creating an individual report and then linking to it. To learn more about customizing clickthrough reports, see Working with Clickthrough Reports.

Next Steps

In the next lesson, you will create a perspective of the model. See Lesson 13: Creating a Perspective