Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

How to: Link Clickthrough Reports to Entities (SharePoint Integrated Mode)

New: 12 December 2006

In Report Builder, a clickthrough report is a report that provides detailed information about the data contained within the main report. A clickthrough report is displayed when the Report Builder user clicks the interactive data that appears in the main report. These reports are automatically generated by the report server.

Bb283247.note(en-US,SQL.90).gifNote:
Clickthrough reports are available only when running SQL Server Enterprise edition. If you are unsure of which version of SQL Server that your organization is running, contact your database administrator.

Instead of using the default single and multiple instance templates that the report server generates, you can create a report in Report Builder and use it as a customized clickthrough report. Then, you can link your report to the model as a single or multiple instance drillthrough report. For more information, see Working with Clickthrough Reports.

  1. If the library is not already open, click its name on the Quick Launch. If the name of your library does not appear, click View All Site Content, and then click the name of your library.

  2. Point to the model for which you want to customize clickthrough reports.

  3. Click the down arrow, and select Manage Clickthrough Reports.

    The Clickthrough Reports page appears.

  4. Select the entity for which you want the clickthrough report to appear.

Bb283247.note(en-US,SQL.90).gifNote:
The primary, or base, entity used in the customized clickthrough report must to be the same entity as the entity you are selecting in step 4.

  1. Click the Single Instance ellipsis (…) button.
  2. Select the customized clickthrough report and click OK.
    When a person views a report and clicks a single instance of the entity you selected in step 4, the customized clickthrough report appears now.
  1. If the library is not already open, click its name on the Quick Launch. If the name of your library does not appear, click View All Site Content, and then click the name of your library.

  2. Point to the model for which you want to customize clickthrough reports.

  3. Click the down arrow, and select Manage Clickthrough Reports.

    The Clickthrough Reports page appears.

  4. Select the entity for which you want the clickthrough report to appear.

Bb283247.note(en-US,SQL.90).gifNote:
The primary, or base, entity used in the customized clickthrough report must to be the same entity as the entity you are selecting in step 4.

  1. Click the Multiple Instances ellipsis (…) button.
  2. Select the customized clickthrough report and click OK.
    When a person views a report and clicks multiple instances of the entity you selected in step 4, the customized clickthrough report appears now.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.