The Advanced Grid Options section allows CDs to customize the grid layout and data presentation by configuring row height, stack headers, and aggregates. The available Advanced Grid Options are:
- Choose Row Height
- Stack Headers
- Aggregates
¶ 1. Choose Row Height
This option allows CDs to choose the grid row height based on the required layout and readability. The supported row height options are:
| Option | Description |
|---|---|
| Compact | Displays records in a compressed format with reduced spacing between rows. |
| Default | Displays records with standard row spacing. |
| Expanded | Displays records with increased row spacing for better readability. |
¶ 2. Stack Headers
This option allows CDs to stack grid headers up to three levels, offering a more organized and user-friendly way to display data. Group related headers and present information in a hierarchical structure.
¶ 3. Aggregates
This option allows CDs to apply aggregate functions such as Count, Sum, Average, Maximum, and Minimum to grid columns.
To configure aggregates:
- In the Grid Properties panel, click Aggregates.
- In the Grid Aggregates window, enable the Enable Aggregates toggle.
- After enabling aggregates, the available grid columns are displayed.
- Use the Select Aggregate dropdown corresponding to each column to choose the required aggregate type.
- Click Save to apply the selected aggregate configurations.
