Drillthrough to Column Detail

A crosstab table does a great job of aggregating data and displaying it in a manner that makes it easy to see its progression or differences. There are times, however, when it's useful to be able to examine the detail data that the crosstab filter used to create the value in each column cell. The Group Drillthrough element provides this functionality.

In the example above, a Group Drillthrough element has been added beneath a Crosstab Table Value Columns element. All of the element's attributes, other than ID, are optional but the example shows a custom caption and export button selections have been entered. More information about the attributes can be found in the element's Element Reference page.

The resulting crosstab table is shown above. When the cursor is hovered over a value cell, a drill-through icon is displayed.

When the icon is clicked, a report containing all of the relevant detail data, like the example shown above, is automatically generated and displayed.

The Group Drillthrough element's attributes allow you to customize the icon image that appears in the crosstab table and certain aspects of the detail report. You can also include Drillthrough Column elements beneath the Group Drillthrough element; they allow you to set the number columns that will appear in the report and to customize their appearance.