Drill-down reports

Topic group Related topics

Drill-down reports display summary information for a report at the beginning of the report. The details of the report appear toward the bottom. Hence the name drill-down—users can drill down from the summary at the top to the details at the bottom.

The Report wizard offers you the option to create a drill-down report. You can also create a drill-down report in the Report designer.

Controlling drill-down reports in the Report designer

In the Report designer (or if you print the report), the summary information of the report is in the headerBand and footerBand of the reportGroup class. The details of the report are in the detailBand.

In a non-drill-down report, the bands are rendered in this order (this example groups on STATE):

1. headerBand for report's reportGroup

• headerBand for state of "CA"

• detailBand 1 for state of "CA"

• detailBand 2 for state of "CA"

• detailBand n for state of "CA"

• footerBand for state of "CA"

• headerBand for state of "PA"

• detailBand 1 for state of "PA"

• detailBand n for state of "PA"

• footerBand for state of "PA"

• footerBand for report's reportGroup

However, in the drill-down report, the bands are rendered in this order:

2. headerBand for report's reportGroup

• footerBand for report's reportGroup

• headerBand for state of "CA"

• footerBand for state of "CA"

• headerBand for state of "PA"

• footerBand for state of "PA"

• detailBand 1 for state of "CA"

• detailBand 2 for state of "CA"

• detailBand n for state of "CA"

• detailBand 1 for state of "PA"

• detailBand n for state of "PA"

...and so on

The drillDown property

You can control the way the drill-down feature works by setting the drillDown property on the reportGroup class. This property is an enumerated type, with the following possible values: