|
![]() |
This tab is optional. You can allow the summary view report user to drill down from summary statistics to the supporting detail by clicking a plus sign icon. When a user clicks a plus sign to perform the drill-down operation, Process Commander uses information in this tab to query the database, sort the results, and present the details.
Define on this tab the fields in each detail or drill-down row.
In contrast to the properties listed on the Content tab, these properties are not limited to those that are exposed as database columns, and may be top-level or embedded properties. However, for best performance, use only top-level properties.
Columns appear in the order listed. Sorting occurs in the order listed.
Field |
Description |
Drilldown To |
|
Configure... |
If you selected Complete this window to configure a drill-down from one summary view to another from a row in the summary view, from one interactive chart to another, or from a summary view or interactive chart to a list view (Only interactive charts, not image charts, can be the source or target.) No data set is passed to the target list view or summary view, only parameters.
Click Apply to save your changes. For an example of this feature, see |
Complete these fields when you select Detailed View
for the Drilldown To value.
Field |
Description |
Enable Sorting? |
Select to allow the user to sort the drill-down display by clicking a column header. |
Fixed Header? |
Select to prevent the header from scrolling if a user scrolls the drill down listing. |
Field |
|
Caption |
Optional. Enter text for a caption for the value in the Field field.
|
Sort |
Select |
HTML Property |
Images and LinksTwo HTML property rules are useful here:
parameters to reporting_image and reporting_link include an activity that
executes upon click. Typically, this activity executes an
HTML rule, displayed in a new window. For an example, see
Pega Developer Network article |
Export HTML Property |
Click the pencil button ( |
Hide |
Select to retrieve this column in the drill-down detail, but to present it in a hidden field in the HTML display. |
Get DISTINCT records |
Select to eliminate duplicate records in the view. |
Get Row Key |
Select to have the report display the key field for each row. |
Detailed View — Data Source and Report Source
These fields are optional when you select Detailed View
for the DrillDown To value.
Field |
Description |
Data Source of Drill Down View | |
|
|
Report Source | |
Page Name |
Enter a clipboard page name to contain the report
contents. (You can't use |
Content Activity |
|
Maximum Value |
Optional. Enter a maximum number of instances to retrieve for the report contents. As a best practice during testing, enter 500. If you leave this blank, the system enforces a limit of 9,999. |
Title of Drill Down Display | |
Optional. Enter text for a title for the drill-down display. |
|
Key of a row |
Identify a property that is present in every row of the drill-down display and uniquely identifies the row. Enter pzInsKey (identifying the handle of an instance) in most cases, where Data Source field is blank or identifies an internal class. If the Data Source identifies an external class, enter the property that forms the key of a row. (A custom GetContent activity must copy this property to the pxInsHandle property in each page within the pxResults list.) |