You can define a report drilldown to allow reporting users to view subsets of the
report data. When you define a report drilldown, it applies only to the report for which you
The report that you want to define a drilldown for must exist.
Note: You can
only drill down to data in the same table as the report. The following report types
do not support the drilldown feature: list, histogram, calendar, control, box, and
The user can now drill down from the top-level report to the specified drilldown
Select the report you want to add a drilldown to.
Click the Show report structure icon ().
A badge on the Report structure icon displays the number of defined
Click the Add drilldown icon ().
Enter a Title for the drilldown and click
Select the chart Type to display the data and click
Next. See Report Builder – Report types and creation details.
The drilldown chart type can be different than the parent report.
Configure the report. Configuration options depend on the selected
Click Save drilldown.
All users can view report
visualizations, such as pie charts and column reports. However, the last level of a
drilldown is always a list. Platform access control lists determine user access to
list information. Users who do not have rights to any part of the list data see the
message "Number of rows removed from this list by Security constraints:" followed by
the number. For more information, see