Skip to main content
Documentatie
Documentatie
Administrator Guide
Laatst bijgewerkt: 2023-09-08
Set Up Composite Report Cells

Set Up Composite Report Cells

  • Create a custom composite report.
  • Configure the columns, rows, and subreports for the composite report.
  • Security: These domains in the System functional area:
    • Custom Report Creation
    • Manage: All Custom Reports
You can configure:
  • Calculation cells that display the result of calculations applied to other cells.
  • Data cells that display data from a matrix or trending subreport.
  • Label cells that display text items on the report, such as headers and titles.
  • Style cells that apply style formatting to selected cells.
You can duplicate columns and rows with calculation or data cells to create columns more easily. When you duplicate cells, Workday retains the configuration of the cell, including the:
  • Cell label.
  • Options selected for the cell.
  • Subreports used in the cell.
  • Style formatting you select.
  1. Access your composite report from the
    Edit Custom Report
     task.
  2. (Optional) On the
    Table
     tab, configure a data cell by selecting
    Define
    Data
     from the menu of an undefined cell.
  3. As you complete the task, consider:
    Optie Omschrijving
    Sub Report Name
    Select an advanced or matrix report to add to your composite report.
    Map Sub Report Prompts
    Configure each prompt field when the:
    • Composite report uses a prompt set.
    • Subreport uses prompts.
    Filter Data in Sub Report
    Complete the grid to filter rows from the advanced, matrix, or trending subreport. Workday keeps the sort order from the subreport when you run the composite report.
    Hide Analytic Indicator
    Select the
    Hide Analytic Indicator
     check box on the
    Options
     prompt to hide visual representations configured on the columns.
  4. (Optional) Configure a calculation cell by selecting
    Define
    Calculation
     from the menu of an undefined cell.
  5. As you complete the task, consider:
    Optie Omschrijving
    Hide Analytic Indicator
    Select the
    Hide Analytic Indicator
     check box on the
    Options
     prompt to hide visual representations configured on the columns.
  6. (Optional) Configure a cell label on the control field column by selecting
    Define
    Label
     from the menu of an undefined cell.
  7. As you complete the task, consider:
    Optie Omschrijving
    Text Expression
    Enter the text that you want to display on your report and enclose variables in brackets.
    Example:
    Headcount in [V1]
    .
    [V1] Variable... [V4] Variable
    When you run the report, Workday replaces the variable with the dynamic value in the variable field, such as the headcount.
  8. (Optional) Configure a conditional override for the cell value by selecting
    Define
    Conditional Value
     from the menu of an undefined cell.
    You can override the value of an undefined cell that intersects a lookup data row and a data column. You can configure the cell to display zero or the actual value based on whether the condition is true or false.
  9. (Optional) Configure a conditional format for the cell value by selecting
    Define
    Conditional Format
     from the menu of an undefined cell.
  10. (Optional) Configure a cell style by selecting
    Style
     from the menu of an undefined cell.
  11. (Optional) Duplicate a data cell configuration by selecting
    Duplicate
     from the menu of a defined cell. You can then select the
    Duplicate to
     location by
    Cells
    ,
    By Row
    , or
    By Column
    .
  12. (Optional) Clear a cell configuration by selecting
    Clear
     from the menu of a defined cell.
    Workday enables you to select
    Clear All
     to clear dependent report components, down to 3 levels of depth in the dependency hierarchy for:
    • Analytic indicators.
    • Cells.
    • Columns.
    • Conditional formatting overrides.
    • Drill down layouts.
    • Override conditions.
    • Rows.