Working with Clickthrough

If you are using Microsoft SQL Server Enterprise or SQL Server Developer, Report Builder includes a special feature called clickthrough. If the report model is designed to support clickthrough (which is called drillthrough in the report model and described in Chapter 9), then a user can explore data interactively by clicking a text box to view the underlying details comprising the selected value (such as a sales amount) or associated with a selected record (such as a product name).

Opening a Clickthrough Report

A user can detect that a clickthrough report is available by pointing to a text box on the report. If the pointer changes to a hand symbol, then the user can click the text box and a new report is created based on ...

Get Microsoft® SQL Server® 2008 Reporting Services Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.