Skip to main content

Timesheet report times out

Add a date filter to the Payroll: Time Data query to stop the timesheet report timing out.

R
Written by Robert Martin

If the timesheet report times out, add a filter on the timesheet dates to the Payroll: Time Data query.
​
The report in the Plugins tab only uses the dates you request. However, when it first runs, it reads all the query data, which can be too much to process in time.

To add a filter to the query, follow these steps:

  1. Click Access Button,

    image

    then click HR Admin.

  2. Click Queries, then click the Payroll: Time Data query.

  3. Click Edit, then click the Filters tab.

  4. Select Timesheet Date from the left-hand side.

  5. In the first field, select This Month, then in the field below, select Last Month.

  6. Select the OR option between the two fields to include data from both months.

This will reduce the data the query is picking up on and will enable this query to run without the need to change any dates after a set period.

Did this answer your question?