Creating a time summary per project

  1. 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
    1. Drag and drop in the input document to the Restructure function
    2. Link the corresponding output parameter to the Name element in the output document.

    Hours
    1. Drag and drop in the input document to the Restructure function
    2. 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 movement is used to 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.
    Rest_ex3b_8003d8f5_8004b3a4.png
  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.