Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2024-01-26
Example: Pay Component Totals by Worker

Example: Pay Component Totals by Worker

This example illustrates how you can create a composite report that sums all pay component totals by worker for a single or multiple periods. Composite reporting uses matrix report types as sub reports to enable you to perform dynamic reporting.
  1. Access the
    Create Custom Report
     task to configure your matrix sub report. Enter:
    Field
    Value
    Report Name
    Pay Component Totals By Worker Subreport
    Report Type
    Matrix
    Data Source
    Payroll Result Lines
  2. Click
    OK
    .
  3. Select
    Pay Calculation Result Lines for Pay Group and Period (As of Sub Period End Date)
     as the
    Data Source Filter
    .
  4. On the
    Matrix
     tab, add these values to the
    Row Grouping
     grid:
    Group By Field
    Sort Rows
    Worker
    Alphabetical - Ascending
    Payroll Calculation
    Alphabetical - Ascending
    Pay Component Category
    If
    Pay Component Category
     isn't displayed in the drop-down, clear the
    Optimized for Performance
     check box on the
    Advanced
     tab. 
    Alphabetical - Ascending
  5. Replace the populated values with these values on the
    Define the Field(s) to Summarize
     grid:
    Summarization Type
    Summarization Field
    Format
    Sum
    Result Line Amount (Indexed)
    #,##0.00
    The
    Result Line Amount (Indexed)
     report field is secured to the
    Public Reporting Items
     domain. If you need security, use the
    Result Line Amount
     report field.
  6. Navigate to the
    Prompts
     tab.
  7. Select the
    Populate Undefined Prompt Defaults
     check box.
    Workday populates the values in your report, but the check box doesn't remain checked.
  8. Select
    Do Not Prompt at Runtime
     for these fields:
    • Organizations
    • Payroll Off-cycle Type
    • Worker
    • Include Subordinate Organizations
  9. On the
    Share
     tab, select
    Share with all authorized users
    .
  10. Click
    OK
    .
  11. Access the
    Create Custom Report
     task and enter:
    Field
    Value
    Report Name
    Pay Component Totals By Worker
    Report Type
    Composite
  12. Add 2 rows on the
    Business Object Enabled for Filtering and Grouping
     grid and enter these business objects:
    • Worker
    • Calculation (Payroll Calculation)
  13. Click
    OK
    .
  14. Click column
    C1
     and select
    Define
    Control Field
     from the drop-down menu.
  15. Enter:
    Field
    Value
    Column Name
    Worker
    Business Object
    Worker
  16. Click
    OK
    .
  17. Click column
    C2
     and select
    Define
    Control Field
    .
  18. Enter:
    Field
    Value
    Column Name
    Description
    Business Object
    Calculation (Payroll Calculation)
  19. Click
    OK
    .
  20. Click column
    C3
     and select
    Define
    Lookup Field Value
    .
  21. Enter:
    Field
    Value
    Column Name
    Code
    Control Field Column
    Description
    Return Field
    Calculation Code
  22. Click
    OK
    .
  23. Click column
    C4
     and select
    Define
    Data
    .
  24. Enter:
    Field
    Value
    Column Name
    Amount
    Sub Report Name
    Pay Component Totals By Worker Subreport
    Workday populates the
    Map Sub Report Prompts
     grid with some of the prompt values you defined in the sub report.
  25. Enter these values in the
    Map Sub Report Prompts
    grid:
    Prompt Field
    Value Type
    Pay Run Groups and/or Pay Group Details
    Prompt User for Value at Run Time
    Periods
    Prompt User for Value at Run Time
  26. From the
    Field to Aggregate
     prompt, select
    Sum of Result Line Amount (Indexed)
    .
  27. Click
    OK
    .