Viewing Clickthrough Reports from a Report (Report Builder)
A clickthrough report is a report that displays related data when you click the interactive data contained within your report. These reports are generated by the report server based on the information contained within the source of data that you are using to create your report. The person who created the data source determines which fields are interactive and which fields are returned when a clickthrough report is opened. These field settings cannot be changed in Report Builder.
|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.|
For example, suppose you run a simple report that lists the employees by department. You have added the following fields to the report: Group Name, Department Name, Title, First Name, and Last Name. When your pointer hovers over the Department Name values, it changes from a pointer to a select link pointer (a hand). If you click the Facilities and Maintenance department name, a new report is displayed. This is a clickthrough report that displays information about the Facilities and Maintenance department. If you click the #Employee Department Histories value, a new report is displayed which shows information about the seven employees that work in the Facilities and Maintenance department. You can continue to clickthrough the related data until you run out of related data to click. When you are ready to return to your original report, click the Back to Parent Report button on the Run Report toolbar.
The fields that are displayed in the clickthrough report provide details about the entity. Using the example above, the following fields are displayed when the department name is clicked: Department ID, Name, Group Name, Modified Date, and #Employee Department Histories. These fields were designated as related detail for the Department entity by the person that created the data source.
Clickthrough reports are displayed using one of two basic design formats, which cannot be customized in Report Builder. Depending on the relationship between the entities within your report, a clickthrough report can be displayed as either a list of fields and values, or a simple table. For example, when you click the Facilities and Maintenance department name, the resulting clickthrough report appears as a list because there is only one Facilities and Maintenance department. The contents of the clickthrough report are oriented vertically similar to the following picture.
Within the Department clickthrough report, the #Employee Department Histories field is interactive. When you click a value, the resulting clickthrough report appears as a basic table because there are many employees within the department. The contents of the clickthrough report are oriented horizontally similar to the following picture.