Creating a time summary per project
-
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
-
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
- 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. -
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.