 |
| ||||||
| Scripting - Running a Report on a Group or a Single Employee | ||||||
| ||||||
| Question | |
| ||||
| I just had a client asking if there is any report that they can select a specific employee only and put in a date range to see the times they worked? | ||||||
| Answer | ||||||
| You can do this with all of our reports (Summary Report, Detail Report, etc.), using a clock prompt and a script. To do this write a script that will automatically fill that prompt with a value from Employee Setup. (Fields that can be used by a script include Department, Supervisor, Location, and Home 1, 2, and 3.) For our example we will use the 'Home 1' field in Employee Setup and Clock Prompt 'x'. Our employee is named 'John Smith' which we will enter that in 'Home 1' of his Employee Setup. More information on creating a prompt can be found here How To - Setting Up Clock Prompts. Lastly we write simple script saying that 'x' equals 'Home 1'. x = Home 1; - TimeWorks version [X_Prompt name] = employee.home1; - TimeWorks Plus version Then we can filter any report by the x-prompt, which in this case will be the individual employee. You can also do this for groups in the same manner by putting in an identifier in Employee Setup for that group for example 'Warehouse' in 'Home 1'. Then you would just run the filter by 'Warehouse'. More information on creating a prompt can be found here How To - Setting Up Clock Prompts. | ||||||
| Back to Search Results | ||||||