Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2025-05-02
Reference: Composite Report Columns

Reference: Composite Report Columns

Workday provides these column types for use in composite reports. You can freeze columns to improve data visibility when scrolling horizontally by clicking
Grid Preferences
 on the table toolbar. Workday disables freezing for composite reports that have:
  • Column or row groupings.
  • Multilevel column headers.
  • Repeating column groups.
Column
Description
Control Field
Sets up the:
  • Combine data row calculation of control field rows.
  • Common business object used across multiple data sources in subreports.
  • Control field used in lookup data rows and lookup field value columns.
A report must have at least 1 control field column, but reports with multiple control field columns can't display results in an outline.
Workday doesn't support control fields in repeating column groups.
Workday supports dynamic control fields for accounting worktags. SeeConcept: Dynamic Control Fields for Accounting Worktags .
Data
Sets up the data pulled from the subreport. A report must have at least 1 data column, dynamic data row, or lookup data row.
Workday aggregates and displays the results of the subreport using the:
  • Aggregation field configured for the data column.
  • Lookup data for the row as filter criteria.
You can enable multiple business objects to be available as dimensions on the same report. Example: The fields
Ledger Account
 and
Ledger Account by Name
 use the same Ledger Account related business object. You can map fields for joining so they become available on the same report.
Lookup Field Value
Enables you to include additional data associated with the business object of the control field column.
This column type doesn't support fields with built-in prompts.
Calculation
References other columns based on these calculation types:
  • Difference: Subtracts the second value from the first value.
  • Divide: Divides the first value by the second value. The second value supports cells when the first value is a column.
  • Multiply: Multiplies 2 values.
  • PercentIncrease: Returns the difference in percentage of the first value from the second value.
  • PercentRemaining: Returns the percentage remaining after dividing the second value by the first value.
  • Sum: Returns the sum of multiple values.
  • SumRange: Returns the sum of all columns, from the first column to the last column.
You can configure drill-down options to specify detail drilling on calculation columns.
Empty
Provides spacing between columns with data. Workday restricts data from the column unless it's overwritten with cell data.
Repeating Column Group
Sets up a column or a series of contiguous columns to repeat based on a value, such as repeating by a company or cost center.
You can use repeating column groups on all column types, except control fields.
Repeating column groups enable you to:
  • Map subreport dimensions for data cells and columns.
  • Reference calculation cells and columns in repeating column groups.
  • Sort a cell value in ascending or descending order.
  • Use column outlining to expand and collapse various levels of data when the report results display.