Hi, I met a problem when Iโm trying to generate a PDF report for my employee task log. I am trying to generate a timesheet log report every first day of the month.
The image below is my docs template and Iโm not sure if I did this correctly. For example, employee 1โs all timesheet log is shown first followed by employee 2 and so on.
Please review the above article in more detail.
START expects a List of key values. I donโt know what โLog IDโ is supposed to be, but it is not a List of key values. If โLog IDโ is a Table name, then you can just add the key column after it to produce a report with all records in that Table, like Log ID[key-column]
You also appears to be missing an <<END>>
statement. It should go after <<Location>>
(which should also have square brackets around it to reference the column value).
I also donโt think your ORDERBY expression in the 2nd column is going to get you what youโre wanting/expecting. What are you intending here?
โLog IDโ is my key column where it will be auto-generated when each employee clocked in to the application.
What Iโm trying to do is to show a timesheet log report based on the example Iโve created in below. Because in the timesheet log, all the employee are mixed up so I want to group them by employee ID for my PDF report.
Then your START expression should be:
START:table-name[Log ID]
You need to use the ORDERBY to affect the order of the List of key values in the START expression, it is doing nothing just sitting by itself in your second column.
Okay, I understand how it actually works now!! Thank you for your guidance
HI,
I am working on a similar app, can you shed some light on your final solution. Also, how do you get the SUM of Total Hours for each Employee.
Thanks.
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |