Attachment template: Trying to report from multiple days with empty values

[rapmachado]

Good evening,

I want to generate a report that seems like:

I already have a table that has the following columns: [Production ID],[Date of production],[Employee],[Process],[Produced Units].

And I’m using the following expression for the first and second columns (name and production from the 1st of the moth):
<<Start: orderby(SELECT([Related Productions][Production ID], [Process]=Process 1, [Date]=Date(moth([Date of production])&"/1/"&year([Date of production])))),[Employee])>><<[Employee]>><<[Produced units]>><>

That gives me:
Employee 1 2
Employee 3 4

So, when I do similarly for the 2nd of the month, I get:
Employee 1 3
Employee 2 5

As you might see, the Issue is that I need to run the expression with all the “active” employees from that period in order to be able to fulfill the 0’s where needed.

I mandatorily need to filter by date, which will modify the employees on the result. I got to a dead end.

I’ll appreciate any ideas in order to solve this situation.