Transfering sorted table to report

[Tritonos_Gruppe]

Hi

I am working on my timelog app and are trying to add my send a report withe hours betwenn 2 dates.

I have it set like this

So I get all my dates sorted, but now I need to transfere this to a word document like this

When I send this mail, it will print out the whole time log not only between those dates.

Hope someone could help med with the last part.

[Jonathan_S]

You need to have a slice based on your start/end time and date settings,

than use that slice for your report

[Steve · Accepted solution]

Try this as your template’s <<Start>> tag:

<<Start: ORDERBY(SELECT(TimeSheet[Timestamp], AND(([User] = USEREMAIL()), (DATE([Timestamp]) >= [_THISROW].[Fra Dato]), (DATE([Timestamp]) <= [_THISROW].[Til Dato]))), [TimeLog], TRUE)>>