I’m building a timesheet app where employees log their work time for different projects. Employee can have many timesheets and every timesheet has a reference to a row in Projects-table.
Report template works fine until the point where I would like to list all projects where the employee has worked and present the sum of work hours in every particular project.
I’ve tried several variations of SELECT() expression but none of them seems to work in a way I would like. I have listed some of the variations and their results in the template file: https://docs.google.com/document/d/14KYEv0ANpQ4cyjH_Bob-d1Q4dsKZ8g3FFDwwaO1R658/edit?usp=sharing
I can generate a correct list of references to Project-table with expression SELECT([Related Timesheets by Employee][Project], TRUE, TRUE) but this is not valid together with template start expression.
[List of reverse references][Column] seems to work in some places (for example the sum expression in the last row in report table, but maybe this is something that is not fully supported?
Any help or comments would be appreciated!