Skip to main content

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:

PropertyDescription
Report TypeSet to Tabular.
Shrink To FitFor 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.