Time summary per project
-
Create loops.
Create a loop controlling the repetitive Project element in the output document.
The loop is controlled by a Restructure function.
-
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. -
-
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.