Hello all,
I have a report that starts with a empty table row.
The output looks like this,
The code for the report is:
Weekoverzicht werktijden
Week: <<[Week]>> <<[Year]>>
<<Start: ORDERBY(FILTER(“Timesheet”, ([Log ID] = MAXROW(“Timesheet”, “_ROWNUMBER”, ([_THISROW-1].[Name] = [Name])))), [Name].[Employee Name])>>
<<[Name].[Employee Name]>>
|
Dag |
Datum |
In |
Uit |
Totaal uren |
|
<<Start: FILTER(“Timesheet”, AND(([_Thisrow].[Week] = [Week]),([_Thisrow-1].[Name] = [Name])))>><<TEXT([Date/Time In], “DDDD”)>> |
<<TEXT([Date/Time In],”DD-MM-YY”)>> |
<<TEXT([Date/Time In],”hh:mm:ss”)>> |
<<TEXT([Date/Time Out],”hh:mm:ss”)>> |
<<TEXT(TIME([Total Hours]),”hh:mm:ss”)>><> |
|
Totaal uren |
<<SUM(SELECT(Timesheet[Total Hours], AND(([_Thisrow].[Week] = [Week]),([_Thisrow-1].[Name] = [Name]))))>> |
<>