Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2024-03-08
Example: Create a Report on the Gender Breakdown of Active Workers

Example: Create a Report on the Gender Breakdown of Active Workers

This example illustrates how to report on multiple data sources by creating a composite report.
You want to create a report that displays the gender of all active employees and contingent workers. You want to use that data so you can publish a statement on the gender breakdown within your organization.
  1. Access the
    Create Custom Report
     task.
    Create a matrix report for the gender breakdown of all active employees.
    1. Enter
      Active Employees Matrix Subreport
       on the
      Report Name
       field.
    2. Select
      Matrix
       from the
      Report Type
       prompt.
    3. Clear the
      Optimized for Performance
       check box.
    4. Select
      All Active Employees
       from the
      Data Source
       prompt.
    5. Click
      OK
      .
    6. On the
      Matrix
       tab, select
      Gender
       from the
      Group by Field
       prompt on the
      Row Grouping
       grid.
    7. Click
      OK
      .
    8. Click
      Done
      .
  2. Access the
    Create Custom Report
     task.
    Create a matrix report for the gender breakdown of all contingent workers.
    1. Enter
      Contingent Workers Matrix Subreport
       on the
      Report Name
       field.
    2. Select
      Matrix
       from the
      Report Type
       prompt.
    3. Clear the
      Optimized for Performance
       check box.
    4. Select
      All Contingent Workers
       from the
      Data Source
       prompt.
    5. Click
      OK
      .
    6. On the
      Matrix
       tab, select
      Gender
       from the
      Group by Field
       prompt on the
      Row Grouping
       grid.
    7. Click
      OK
      .
    8. Click
      Done
      .
  3. Access the
    Create Custom Report
     task.
    Create a composite report for the gender of all active employees and contingent workers.
    1. Enter
      Gender Breakdown Composite Report
       in the
      Report Name
       field.
    2. Select
      Composite
       from the
      Report Type
       prompt.
    3. In the
      Business Object Enabled for Filtering and Grouping
       grid, select
      Gender
       on the
      Business Object
       prompt.
    4. Click
      OK
      .
    5. Access the
      Control Field Columns
       section on the
      Columns
       tab.
    6. Click
      Add Column
      .
    7. Enter
      Gender
       in the
      Column Name
       field.
    8. Select
      First (Top)
       from the
      Column Location
       prompt.
    9. Click
      OK
      .
    10. In the
      Data Columns
       section, click
      Add Column
      .
    11. Enter
      Employees
       on the
      Column Name
       field.
    12. In the
      Sub Report
       section, select
      Active Employees Matrix Subreport
       from the
      Sub Report Name
       prompt.
    13. Click
      OK
      .
    14. In the
      Data Columns
       section, click
      Add Column
      .
    15. Enter
      Contingent Workers
       in the
      Column Name
       field.
    16. On the
      Sub Report
       section, select
      Contingent Workers Matrix Subreport
       from the
      Sub Report Name
       prompt.
    17. Click
      OK
      .
    18. Click
      Run
      .
Workday displays a composite report with the gender breakdown of all active employees and contingent workers. Each gender row displays a count for each worker type that you can drill into and view additional details on.