Create Drill-Down Reports

This tutorial describes how to create a drill-down report. Clicking a link in such a report displays the previously hidden detailed information in the same report:

Do the following to create a drill-down report:

1. Create a master-detail report using Detail Report bands.

2. Drop a label onto the report's detail band. Clicking this label should expand or collapse the hidden report details.

3. Select the detail report band, open the Behavior category and expand drop-down menu for the band's Drill-Down Control property in the Properties panel.

   This menu displays all report controls available on the report band that is one level above the current band in the report bands' hierarchy. Select the corresponding label in the menu to make the label expand or collapse the detail report's band when clicked in the Print Preview.

   

   You can also specify the band's Drill-Down Expanded property to define whether or not the band is initially expanded. This property is enabled by default.

4. Select the label, expand the Actions category and click the Expression property's ellipsis button.

   

   This invokes the Expression Editor where you can make the label display different text based on the detail report's DrillDownExpanded property value.