Time summary per project

  1. Create loops.

    Create a loop controlling the repetitive Project element in the output document.

    The loop is controlled by a Restructure function.

  2. Select data and input loop levels.

    Follow these element movements.

    Element Movement
    Project
    • Drag and drop in the input document to the Restructure function, and

    • Link the corresponding output parameter to the Name element in the output document.

    Hours
    • Drag and drop in the input document to the Restructure function, and

    • Link the corresponding output parameter to the TotalHours element in the output document.

    both the Time and Employee repeating elements

    • Drag and drop from the input document to the Restructure function’s header.

    This will get all time transactions for all employees.

    Note: If we forget the link from the Employee element, we only get time transactions for the first employee.
  3. Set and group the data.

    Follow these property settings:

    Property Setting
    Sorting Sequence 1 for project
    Is Grouped true for project
    Is Summable true for Hours.

    Now, you have created a mapping for a simple time summary per project.