To find this information, you will need to create a query per user type. The first three steps are the same for both employee and manager reports, however the query filters differ.
To create the queries, follow the steps below.
Click Access Button
then click HR Admin.
Click Queries then click the plus + icon.
In the left-side area, select Absences.
Then, in the right selection area, tick:
Reports To
Sick Start Date
Sick End Date
Sick Reason
Sick Return To Work Form Required
Sick Manager Declaration
Sick Manager Declaration Date
Click Next, then click Sick Return To Work Form Required.
Select Equals, then select Yes.
To show the cases where this hasn't been completed by the manager, filter on Sick Manager Declaration by selecting Equals and then No.
To show the cases where this hasn't been completed by the employee, filter on Sick Employee Declaration by selecting Equals and then No.
Click Next then enter a name, description and category.
Click Next again.