I stucked with a report trying to set the correct start expression. I have a main “Log” table which contains working hours by employees. I want to generate a report listing all logs for a particular period.
In order to do so, I created a “report request” table. A report request contains Start date and End date columns.
I added 2 virtual columns [corresponding logs] and [corresponding employees] with an expression to select rows from the “Log” table that fit the desired report period. The list is correct :
SELECT(log[ID], AND([_THISROW].[start date] <=[date], [_THISROW].[end date] >=[date]), TRUE)
SELECT(log[Employee], AND([_THISROW].[start date] <=[date], [_THISROW].[end date] >=[date]), TRUE)
When I create the report I want for each employee, the correponding logs listed and ordered by date. I wrote :
<<Start:SELECT([corresponding log][ID), [employee]=[_THISROW].[ID], true)>>
This is not working but can’t figure out how to write the expression. If anyone could point the good direction.