Tabular Report
A Tabular report displays records in rows and columns. Use it for detailed, row-level output or grouped totals when users need to inspect the underlying records.
Configuration
In addition to the basic report properties, configure the following:
| Property | Description |
|---|---|
| Report Type | Set to Tabular. |
| Shrink To Fit | For Standard definitions, automatically fits columns to the available width. |
For a Standard definition, configure the report fields or columns and choose any supported aggregate such as None, Count, Sum, or Average.
Row order and Sort By
- By default, and when Sort By is ticked on the group column, rows follow the group order: the option sequence for a picklist, the lifecycle order for State, oldest first for Date, smallest first for Number, and alphabetical for Text.
- When Sort By is ticked on a value column, rows are sorted by that value, smallest first.
- Users can click a column header to sort by that column; clicking again reverses the order.
See Value Order and Sort By for details.
Example
name: "salesTabular"
displayName: "Sales Report"
dataSource: "SalesProgram"
reportDisplayType: "Tabular"
definition: "Standard"
precision: 2
grandTotals: "On"
exportToCsv: true
exportToExcel: true
showStateFilter: true
Tips
- If the report is empty, check the Data Source, Definition, and configured fields.
- Enable pagination for large result sets.
- Use Date or DateTime attributes when grouping records by time.
- Use CSV or Excel export when users need to work with the detailed result outside the application.
Success criteria
The report renders rows when reportDisplayType is Tabular and its fields or columns are configured.