How do I filter approved hours into a report?

Question

How do I filter approved hours into a report?

Answer

To filter in time entries that are approved at a particular level, you can use the following sql filter statement:

To include Level 1 Approved time entries use: t_timeentry.apprv1=1

To include Level 1 Approved time entries use:  t_timeentry.apprv2=2

To include Level 1 Approved time entries use:  t_timeentry.apprv3=3

To include Level 1 Approved use: t_timeentry.apprv4=4

This sql filter will include all time entries approved at the referenced approval level.

Note: 
These sql filters can be used for any time entry summary report or the timesheet details report.